APPS.GHR_SF52_DO_UPDATE dependencies on GHR_NOA_FAMILIES

Line 1295: from ghr_noa_families nof

1291: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1292: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1293: Cursor get_to_posn_title_pm is
1294: select fpm.process_method_code
1295: from ghr_noa_families nof
1296: ,ghr_families fam
1297: ,ghr_noa_fam_proc_methods fpm
1298: ,ghr_pa_data_fields pdf
1299: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id

Line 1333: select noa_family_code from ghr_noa_families

1329: where pa_request_id=p_pa_request_id and first_noa_code='002';
1330:
1331:
1332: Cursor fam_code(p_second_noa_id number) is
1333: select noa_family_code from ghr_noa_families
1334: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
1335: AND
1336: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
1337: where noa_family_code='APPT_TRANS');

Line 1336: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families

1332: Cursor fam_code(p_second_noa_id number) is
1333: select noa_family_code from ghr_noa_families
1334: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
1335: AND
1336: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
1337: where noa_family_code='APPT_TRANS');
1338:
1339: --
1340: -- 2839332

Line 2865: l_noa_family_code ghr_noa_families.noa_family_code%type;

2861: l_state per_addresses.region_2%type;
2862: l_postal_code per_addresses.postal_code%type;
2863: l_country per_addresses.country%type;
2864: l_noa_family_name varchar2(60);
2865: l_noa_family_code ghr_noa_families.noa_family_code%type;
2866: --
2867: -- hr_person_api.update_person out variables
2868: --
2869: l_per_upd_employee_number per_people_f.employee_number%type;

Line 3034: from ghr_noa_families nfa,

3030: -- Family Code
3031:
3032: Cursor c_noa_family_code IS
3033: Select fam.noa_family_code
3034: from ghr_noa_families nfa,
3035: ghr_families fam
3036: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
3037: and nfa.noa_family_code = fam.noa_family_code
3038: and fam.update_hr_flag = 'Y';

Line 3315: from ghr_noa_families nof

3311:
3312: -- JH Get To Position Title PM for Noa Code being updated.
3313: Cursor get_to_posn_title_pm is
3314: select fpm.process_method_code
3315: from ghr_noa_families nof
3316: ,ghr_families fam
3317: ,ghr_noa_fam_proc_methods fpm
3318: ,ghr_pa_data_fields pdf
3319: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id