Query to fetch Menu's sub menus and function names

Select fmv.menu_id, 
                  Lpad (Level, Level) || Decode (fffv.function_name, Null, ' >') "Level  ", 
                  fmev.entry_sequence seq, 
                  fmv.menu_name, 
                  fmv.user_menu_name, 
                  Nvl (fmev.prompt, '##### NOT DISPLAYED #####') prompt, 
                  Nvl (fffv.function_name, '***** SUB-MENU *****') function_name, 
                  Nvl (fffv.user_function_name, '***** SUB-MENU *****') user_function_name, 
                  fffv.parameters 
             From fnd_menu_entries_vl fmev, fnd_menus_vl fmv, fnd_form_functions_vl fffv 
            Where fmv.menu_id = fmev.menu_id And fffv.function_id(+) = fmev.function_id And Nvl (fmev.grant_flag, 'N') = 'Y' 
       Start With fmv.menu_name =  :start_menu_name 
       Connect By Prior fmev.sub_menu_id = fmev.menu_id 
Order Siblings By fmev.entry_sequence  

Back end tables storing data for Job related Special Info. Type(SIT)

I am currently working on a requirement to insert/update/delete some Job related SIT info. This SIT screen would open when we click on the requirements button Job form in works structures.

Generally person related SIT data is stored in per_person_analyses and per_analysis_criteria tables, which is known to most of us. But what about Job related SIT?

In case of Job related SIT, data is stored in 2 tables- per_analysis_criteria and the other table is per_job_requirements. You will not find the analysis_criteria_id in per_person_analyses table, but you can find the same in per_job_requirements table.

per_analysis_criteria,per_job_requirements---join and query them and check the output.