APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_FAMILIES

Line 496: ghr_families fam

492: and rei.information_type not in
493: (Select pit.information_type
494: from ghr_pa_request_info_types pit,
495: ghr_noa_families nfa,
496: ghr_families fam
497: where nfa.nature_of_action_id in (p_first_noa_id, p_second_noa_id)
498: and nfa.noa_family_code = fam.noa_family_code
499: and fam.pa_info_type_flag = 'Y'
500: and pit.noa_family_code = fam.noa_family_code);

Line 764: ghr_families fam

760: Cursor c_info_types(c_application_id fnd_application.application_id%type,c_resp_id fnd_responsibility.responsibility_id%type) is
761: Select pit.information_type
762: from ghr_pa_request_info_types pit,
763: ghr_noa_families nfa,
764: ghr_families fam
765: where nfa.nature_of_action_id = p_noa_id
766: and nfa.noa_family_code = fam.noa_family_code
767: and p_effective_date between NVL(nfa.start_date_active,p_effective_date)
768: and NVL(nfa.end_date_active,p_effective_date)

Line 4019: ghr_families fam

4015: Cursor c_info_type is
4016: Select pit.information_type
4017: from ghr_pa_request_info_types pit,
4018: ghr_noa_families nfa,
4019: ghr_families fam
4020: where nfa.nature_of_action_id = p_noa_id
4021: and nfa.noa_family_code = fam.noa_family_code
4022: and fam.pa_info_type_flag = 'Y'
4023: and pit.noa_family_code = fam.noa_family_code