APPS.GHR_SF52_DO_UPDATE dependencies on FND_ID_FLEX_STRUCTURES

Line 1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

1023: ) is
1024:
1025: l_proc varchar2(72) := 'Generic Sit';
1026: l_business_group_id per_people_f.business_group_id%type;
1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%type;
1031: l_year_degree_attained ghr_pa_requests.year_degree_attained%type;

Line 1044: from fnd_id_flex_structures_tl

1040: -- Cursor to fetch the id_flex_num for the "US Fed Education" structure
1041:
1042: Cursor c_flex_num is
1043: select id_flex_num
1044: from fnd_id_flex_structures_tl
1045: where id_flex_structure_name = 'US Fed Education'
1046: and language = 'US';
1047: -- and id_flex_code = 'PEA' --??
1048: -- and application_id = 800 --??

Line 8511: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,

8507: End get_wgi_dates;
8508: --
8509: Procedure generic_update_sit
8510: (p_pa_request_rec in ghr_pa_requests%rowtype,
8511: p_special_information_type in fnd_id_flex_structures_tl.id_flex_structure_name%type,
8512: p_segment_rec in ghr_api.special_information_type
8513: )
8514: is
8515:

Line 8523: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8522: l_business_group_id per_people_f.business_group_id%type;
8523: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8524: -- Bug#4054110,4069798 Added l_date_from variable
8525: l_date_from DATE;
8526:
8527: Cursor c_bgpid is

Line 8534: from fnd_id_flex_structures_tl

8530: where person_id = p_pa_request_rec.person_id;
8531:
8532: Cursor c_flex_num is
8533: select id_flex_num
8534: from fnd_id_flex_structures_tl
8535: where id_flex_structure_name = p_special_information_type
8536: and id_flex_code = 'PEA' --??
8537: and application_id = 800
8538: and language = 'US'; --??