eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF52_DO_UPDATE dependencies on GHR_FAMILIES

Line 1312: ,ghr_families fam

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
1316: and nof.noa_family_code = fam.noa_family_code

Line 3239: ghr_families fam

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';
3243:

Line 3533: ,ghr_families fam

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
3537: and nof.noa_family_code = fam.noa_family_code

Line 5008: l_noa_family_code ghr_families.noa_family_code%type;

5004: ,p_capped_other_pay in number default null
5005: ) is
5006:
5007: l_proc varchar2(70) := 'Process_salary_info';
5008: l_noa_family_code ghr_families.noa_family_code%type;
5009: l_adj_basic_pay_warn boolean;
5010: l_element_entry_id number;
5011: l_basic_pay_warn boolean;
5012: l_locality_adj_warn boolean;