APPS.GHR_SF52_DO_UPDATE dependencies on FND_ID_FLEX_STRUCTURES_TL

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