APPS.GHR_CORR_CANC_SF52 dependencies on GHR_FAMILIES

Line 1720: l_noa_family_code ghr_families.noa_family_code%type;

1716: l_result boolean;
1717: l_deleted boolean;
1718: l_system_type per_person_types.system_person_type%type;
1719: l_prior_noa_code ghr_nature_of_actions.code%type;
1720: l_noa_family_code ghr_families.noa_family_code%type;
1721: l_prior_asg_id per_assignments_f.assignment_id%type; --Bug# 5442674
1722:
1723: -- bug #6312144
1724: l_imm_ipa_benefits_cont ghr_api.per_ipa_ben_cont_info_type;

Line 1779: ghr_families fam

1775:
1776: Cursor c_noa_family(p_noa_id in number) is
1777: Select fam.noa_family_code
1778: from ghr_noa_families nof,
1779: ghr_families fam
1780: where nof.nature_of_action_id = p_noa_id
1781: and fam.noa_family_code = nof.noa_family_code
1782: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
1783: and p_sf52_data.effective_date

Line 2660: ghr_families fams

2656: cursor c_fam (c_noa_id number) is
2657: select
2658: fams.noa_family_code
2659: from ghr_noa_families noafam,
2660: ghr_families fams
2661: where noafam.nature_of_action_id = c_noa_id and
2662: noafam.enabled_flag = 'Y' and
2663: fams.noa_family_code = noafam.noa_family_code and
2664: fams.enabled_flag = 'Y' and

Line 6242: ghr_families fams

6238: cursor c_fam (c_noa_id in number) is
6239: select
6240: fams.noa_family_code
6241: from ghr_noa_families noafam,
6242: ghr_families fams
6243: where noafam.nature_of_action_id = c_noa_id and
6244: noafam.enabled_flag = 'Y' and
6245: fams.noa_family_code = noafam.noa_family_code and
6246: fams.enabled_flag = 'Y' and

Line 7340: ghr_families fam

7336: Cursor c_noa_family(p_noa_id in number)
7337: is
7338: Select fam.noa_family_code
7339: from ghr_noa_families nof,
7340: ghr_families fam
7341: where nof.nature_of_action_id = p_noa_id
7342: and fam.noa_family_code = nof.noa_family_code
7343: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'
7344: and p_sf52_data.effective_date