APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PAY_PLANS

Line 799: ghr_pay_plans pp

795: cursor c_noac_1xx is
796: SELECT par.effective_date
797: FROM ghr_nature_of_actions noa,
798: ghr_pa_requests par,
799: ghr_pay_plans pp
800: WHERE noa.nature_of_action_id = par.first_noa_id
801: and par.pa_request_id = p_pa_request_id
802: and pp.pay_plan = par.to_pay_plan
803: and pp.equivalent_pay_plan in ('GS','FW')

Line 811: ghr_pay_plans pp

807: cursor c_noac_5xx is
808: SELECT par.effective_date
809: FROM ghr_nature_of_actions noa,
810: ghr_pa_requests par,
811: ghr_pay_plans pp
812: WHERE noa.nature_of_action_id = par.first_noa_id
813: and par.pa_request_id = p_pa_request_id
814: and pp.pay_plan = par.to_pay_plan
815: and pp.equivalent_pay_plan in ('GS','FW')

Line 823: ghr_pay_plans pp

819: cursor c_noac_130 is
820: SELECT par.effective_date
821: FROM ghr_nature_of_actions noa,
822: ghr_pa_requests par,
823: ghr_pay_plans pp
824: WHERE noa.nature_of_action_id = par.first_noa_id
825: and par.pa_request_id = p_pa_request_id
826: and pp.pay_plan = par.to_pay_plan
827: and pp.equivalent_pay_plan in ('GS','FW')

Line 835: ghr_pay_plans pp

831: cursor c_noac_sal_chg is
832: SELECT par.effective_date
833: FROM ghr_nature_of_actions noa,
834: ghr_pa_requests par,
835: ghr_pay_plans pp
836: WHERE noa.nature_of_action_id = par.first_noa_id
837: AND par.pa_request_id = p_pa_request_id
838: AND pp.pay_plan = par.to_pay_plan
839: AND pp.equivalent_pay_plan in ('GS','FW')