APPS.GHR_SF52_DO_UPDATE dependencies on FND_ID_FLEX_STRUCTURES

Line 1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

1008: ) is
1009:
1010: l_proc varchar2(72) := 'Generic Sit';
1011: l_business_group_id per_people_f.business_group_id%type;
1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%type;
1016: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

Line 1029: from fnd_id_flex_structures_tl

1025: -- Cursor to fetch the id_flex_num for the "US Fed Education" structure
1026:
1027: Cursor c_flex_num is
1028: select id_flex_num
1029: from fnd_id_flex_structures_tl
1030: where id_flex_structure_name = 'US Fed Education'
1031: and language = 'US';
1032: -- and id_flex_code = 'PEA' --??
1033: -- and application_id = 800 --??

Line 8208: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,

8204: End get_wgi_dates;
8205: --
8206: Procedure generic_update_sit
8207: (p_pa_request_rec in ghr_pa_requests%rowtype,
8208: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8209: p_segment_rec in ghr_api.special_information_type
8210: )
8211: is
8212:

Line 8220: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8219: l_business_group_id per_people_f.business_group_id%type;
8220: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8221: -- Bug#4054110,4069798 Added l_date_from variable
8222: l_date_from DATE;
8223:
8224: Cursor c_bgpid is

Line 8231: from fnd_id_flex_structures_tl

8227: where person_id = p_pa_request_rec.person_id;
8228:
8229: Cursor c_flex_num is
8230: select id_flex_num
8231: from fnd_id_flex_structures_tl
8232: where id_flex_structure_name = p_special_information_type
8233: and id_flex_code = 'PEA' --??
8234: and application_id = 800
8235: and language = 'US'; --??