APPS.GHR_CORR_CANC_SF52 dependencies on GHR_NOA_FAMILIES

Line 1605: from ghr_noa_families nof,

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

Line 2398: from ghr_noa_families noafam,

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

Line 5338: from ghr_noa_families fam

5334: FUNCTION get_record_category(p_sf52_record IN ghr_pa_requests%ROWTYPE)
5335: RETURN NUMBER IS
5336: CURSOR c_noa_fam_code(c_noa_id NUMBER) is
5337: select fam.noa_family_code family_code
5338: from ghr_noa_families fam
5339: where fam.nature_of_action_id = c_noa_id;
5340:
5341: l_found VARCHAR2(10) := 'FALSE';
5342: l_proc VARCHAR2(30) := 'get_record_category';

Line 5888: from ghr_noa_families noafam,

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

Line 6659: from ghr_noa_families fam

6655:
6656:
6657: cursor c_noa_fam_code(p_noa_id ghr_nature_of_actions.nature_of_action_id%type) is
6658: select fam.noa_family_code
6659: from ghr_noa_families fam
6660: where fam.nature_of_action_id = p_noa_id;
6661:
6662:
6663: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';

Line 6667: l_noa_fam_code ghr_noa_families.noa_family_code%type;

6663: l_proc varchar2(30):='get_sf52_to_othpays_for_ia';
6664: l_dummy_varchar varchar2(1);
6665: l_sf52_ia_rec ghr_pa_requests%rowtype;
6666: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
6667: l_noa_fam_code ghr_noa_families.noa_family_code%type;
6668:
6669: BEGIN
6670: -- First assign the current From pos items to To pos items
6671: hr_utility.set_location( 'Entering ' || l_proc, 5);