APPS.GHR_SF52_DO_UPDATE dependencies on GHR_NOA_FAMILIES

Line 1311: from ghr_noa_families nof

1307: l_Organ_Component per_position_extra_info.poei_information5%type; --/
1308: -- JH Get To Position Title PM for Noa Code being updated. Bug 773851
1309: Cursor get_to_posn_title_pm is
1310: select fpm.process_method_code
1311: from ghr_noa_families nof
1312: ,ghr_families fam
1313: ,ghr_noa_fam_proc_methods fpm
1314: ,ghr_pa_data_fields pdf
1315: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id

Line 1349: select noa_family_code from ghr_noa_families

1345: where pa_request_id=p_pa_request_id and first_noa_code='002';
1346:
1347:
1348: Cursor fam_code(p_second_noa_id number) is
1349: select noa_family_code from ghr_noa_families
1350: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
1351: AND
1352: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
1353: where noa_family_code='APPT_TRANS');

Line 1352: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families

1348: Cursor fam_code(p_second_noa_id number) is
1349: select noa_family_code from ghr_noa_families
1350: where nature_of_action_id=p_second_noa_id and noa_family_code='APP'
1351: AND
1352: nature_of_action_id not in (select nature_of_action_id from ghr_noa_families
1353: where noa_family_code='APPT_TRANS');
1354:
1355: --
1356: -- 2839332

Line 3069: l_noa_family_code ghr_noa_families.noa_family_code%type;

3065: l_state per_addresses.region_2%type;
3066: l_postal_code per_addresses.postal_code%type;
3067: l_country per_addresses.country%type;
3068: l_noa_family_name varchar2(60);
3069: l_noa_family_code ghr_noa_families.noa_family_code%type;
3070: --
3071: -- hr_person_api.update_person out variables
3072: --
3073: l_per_upd_employee_number per_people_f.employee_number%type;

Line 3238: from ghr_noa_families nfa,

3234: -- Family Code
3235:
3236: Cursor c_noa_family_code IS
3237: Select fam.noa_family_code
3238: from ghr_noa_families nfa,
3239: ghr_families fam
3240: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
3241: and nfa.noa_family_code = fam.noa_family_code
3242: and fam.update_hr_flag = 'Y';

Line 3532: from ghr_noa_families nof

3528:
3529: -- JH Get To Position Title PM for Noa Code being updated.
3530: Cursor get_to_posn_title_pm is
3531: select fpm.process_method_code
3532: from ghr_noa_families nof
3533: ,ghr_families fam
3534: ,ghr_noa_fam_proc_methods fpm
3535: ,ghr_pa_data_fields pdf
3536: where nof.nature_of_action_id = p_pa_request_rec.first_noa_id