APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_NOA_FAMILIES

Line 495: ghr_noa_families nfa,

491: 'GHR_US_PD_GEN_EMP')
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'

Line 664: l_noa_family_code ghr_noa_families.noa_family_code%type;

660: l_per_refresh_flag varchar2(1);
661: l_asg_refresh_flag varchar2(1);
662: l_pos_refresh_flag varchar2(1);
663: -- Bug#4089400
664: l_noa_family_code ghr_noa_families.noa_family_code%type;
665: -- Bug#5039072 Added the following two parameters.
666: l_first_noa_code ghr_pa_requests.first_noa_code%type;
667: l_la_code1 ghr_pa_requests.first_action_la_code1%type;
668: l_payment_option ghr_pa_requests.pa_incentive_payment_option%type;

Line 763: ghr_noa_families nfa,

759: -- Bug#3941541 Added effective date condition to the cursor.
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)

Line 3466: l_noa_family_code ghr_noa_families.noa_family_code%type;

3462: l_assignment_id per_assignments_f.assignment_id%type;
3463: l_per_refresh_flag varchar2(1);
3464: l_asg_refresh_flag varchar2(1);
3465: l_business_group_id per_assignments_f.business_group_id%type;
3466: l_noa_family_code ghr_noa_families.noa_family_code%type;
3467:
3468: l_proc varchar2(72) := g_package || 'fetch_gneric_extra_info';
3469: l_information_type ghr_pa_request_extra_info.information_type%type;
3470: l_person_type per_person_types.system_person_type%type := hr_api.g_varchar2;

Line 4018: ghr_noa_families nfa,

4014:
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'