[Home] [Help]
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
1300: and nof.noa_family_code = fam.noa_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';
3039:
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
3320: and nof.noa_family_code = fam.noa_family_code
4745: ,p_capped_other_pay in number default null
4746: ) is
4747:
4748: l_proc varchar2(70) := 'Process_salary_info';
4749: l_noa_family_code ghr_families.noa_family_code%type;
4750: l_adj_basic_pay_warn boolean;
4751: l_element_entry_id number;
4752: l_basic_pay_warn boolean;
4753: l_locality_adj_warn boolean;