APPS.GHR_CORR_CANC_SF52 dependencies on GHR_NOA_FAMILIES

Line 1778: from ghr_noa_families nof,

1774: where par.pa_request_id = p_sf52_data.altered_pa_request_id;
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'

Line 2659: from ghr_noa_families noafam,

2655: -- this cursor gets the noa_family_code for noa_id (nature of action ID) passed.
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

Line 5688: from ghr_noa_families fam

5684: FUNCTION get_record_category(p_sf52_record IN ghr_pa_requests%ROWTYPE)
5685: RETURN NUMBER IS
5686: CURSOR c_noa_fam_code(c_noa_id NUMBER) is
5687: select fam.noa_family_code family_code
5688: from ghr_noa_families fam
5689: where fam.nature_of_action_id = c_noa_id;
5690:
5691: l_found VARCHAR2(10) := 'FALSE';
5692: l_proc VARCHAR2(30) := 'get_record_category';

Line 6241: from ghr_noa_families noafam,

6237: -- cursor to fetch noa_family_code for the given noa_id.
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

Line 7014: from ghr_noa_families fam

7010:
7011:
7012: cursor c_noa_fam_code(p_noa_id ghr_nature_of_actions.nature_of_action_id%type) is
7013: select fam.noa_family_code
7014: from ghr_noa_families fam
7015: where fam.nature_of_action_id = p_noa_id;
7016:
7017:
7018: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';

Line 7022: l_noa_fam_code ghr_noa_families.noa_family_code%type;

7018: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';
7019: l_dummy_varchar varchar2(1);
7020: l_sf52_ia_rec ghr_pa_requests%rowtype;
7021: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
7022: l_noa_fam_code ghr_noa_families.noa_family_code%type;
7023:
7024: BEGIN
7025: -- First assign the current From pos items to To pos items
7026: hr_utility.set_location( 'Entering ' || l_proc, 5);

Line 7339: from ghr_noa_families nof,

7335: -- 8264545
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'