APPS.GHR_SF52_DO_UPDATE dependencies on FND_ID_FLEX_STRUCTURES_TL

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 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'; --??