APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_FAMILIES

Line 543: ghr_families fam

539: and rei.information_type not in
540: (Select pit.information_type
541: from ghr_pa_request_info_types pit,
542: ghr_noa_families nfa,
543: ghr_families fam
544: where nfa.nature_of_action_id in (p_first_noa_id, p_second_noa_id)
545: and nfa.noa_family_code = fam.noa_family_code
546: and fam.pa_info_type_flag = 'Y'
547: and pit.noa_family_code = fam.noa_family_code);

Line 826: ghr_families fam

822: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is
823: Select pit.information_type
824: from ghr_pa_request_info_types pit,
825: ghr_noa_families nfa,
826: ghr_families fam
827: where nfa.nature_of_action_id = p_noa_id
828: and nfa.noa_family_code = fam.noa_family_code
829: and p_effective_date between NVL(nfa.start_date_active,p_effective_date)
830: and NVL(nfa.end_date_active,p_effective_date)

Line 4776: ghr_families fam

4772: Cursor c_info_type is
4773: Select pit.information_type
4774: from ghr_pa_request_info_types pit,
4775: ghr_noa_families nfa,
4776: ghr_families fam
4777: where nfa.nature_of_action_id = p_noa_id
4778: and nfa.noa_family_code = fam.noa_family_code
4779: and fam.pa_info_type_flag = 'Y'
4780: and pit.noa_family_code = fam.noa_family_code