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_NON_SF52_EXTRA_INFO dependencies on GHR_PAY_PLANS

Line 865: ghr_pay_plans pp

861: cursor c_noac_1xx is
862: SELECT par.effective_date
863: FROM ghr_nature_of_actions noa,
864: ghr_pa_requests par,
865: ghr_pay_plans pp
866: WHERE noa.nature_of_action_id = par.first_noa_id
867: and par.pa_request_id = p_pa_request_id
868: and pp.pay_plan = par.to_pay_plan
869: and pp.equivalent_pay_plan in ('GS','FW')

Line 877: ghr_pay_plans pp

873: cursor c_noac_5xx is
874: SELECT par.effective_date
875: FROM ghr_nature_of_actions noa,
876: ghr_pa_requests par,
877: ghr_pay_plans pp
878: WHERE (noa.nature_of_action_id = par.first_noa_id
879: ---Bug# 8263918
880: OR
881: (noa.nature_of_action_id = par.second_noa_id

Line 895: ghr_pay_plans pp

891: cursor c_noac_130 is
892: SELECT par.effective_date
893: FROM ghr_nature_of_actions noa,
894: ghr_pa_requests par,
895: ghr_pay_plans pp
896: WHERE noa.nature_of_action_id = par.first_noa_id
897: and par.pa_request_id = p_pa_request_id
898: and pp.pay_plan = par.to_pay_plan
899: and pp.equivalent_pay_plan in ('GS','FW')

Line 907: ghr_pay_plans pp

903: cursor c_noac_sal_chg is
904: SELECT par.effective_date
905: FROM ghr_nature_of_actions noa,
906: ghr_pa_requests par,
907: ghr_pay_plans pp
908: WHERE (noa.nature_of_action_id = par.first_noa_id
909: ---Bug# 8263918
910: OR
911: (noa.nature_of_action_id = par.second_noa_id