APPS.GHR_CORR_CANC_SF52 dependencies on GHR_FAMILIES

Line 1551: l_noa_family_code ghr_families.noa_family_code%type;

1547: l_result boolean;
1548: l_deleted boolean;
1549: l_system_type per_person_types.system_person_type%type;
1550: l_prior_noa_code ghr_nature_of_actions.code%type;
1551: l_noa_family_code ghr_families.noa_family_code%type;
1552: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1553:
1554: -- bug #6312144
1555: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

Line 1606: ghr_families fam

1602:
1603: Cursor c_noa_family(p_noa_id in number) is
1604: Select fam.noa_family_code
1605: from ghr_noa_families nof,
1606: ghr_families fam
1607: where nof.nature_of_action_id = p_noa_id
1608: and fam.noa_family_code = nof.noa_family_code
1609: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
1610: and p_sf52_data.effective_date

Line 2399: ghr_families fams

2395: cursor c_fam (c_noa_id number) is
2396: select
2397: fams.noa_family_code
2398: from ghr_noa_families noafam,
2399: ghr_families fams
2400: where noafam.nature_of_action_id = c_noa_id and
2401: noafam.enabled_flag = 'Y' and
2402: fams.noa_family_code = noafam.noa_family_code and
2403: fams.enabled_flag = 'Y' and

Line 5889: ghr_families fams

5885: cursor c_fam (c_noa_id in number) is
5886: select
5887: fams.noa_family_code
5888: from ghr_noa_families noafam,
5889: ghr_families fams
5890: where noafam.nature_of_action_id = c_noa_id and
5891: noafam.enabled_flag = 'Y' and
5892: fams.noa_family_code = noafam.noa_family_code and
5893: fams.enabled_flag = 'Y' and