APPS.GHR_MLC_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 3525: from ghr_pa_requests pr, ghr_pa_routing_history prh

3521: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3522:
3523: cursor csr_action_taken is
3524: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3525: from ghr_pa_requests pr, ghr_pa_routing_history prh
3526: where pr.pa_request_id = prh.pa_request_id
3527: and person_id = p_person_id
3528: and first_noa_code = p_first_noa_code
3529: and effective_date = p_effective_date

Line 3542: from ghr_pa_requests pr, ghr_pa_routing_history prh

3538: where pr.pa_request_id = l_pa_request_id;
3539:
3540: cursor csr_action_taken_fw is
3541: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3542: from ghr_pa_requests pr, ghr_pa_routing_history prh
3543: where pr.pa_request_id = prh.pa_request_id
3544: and person_id = p_person_id
3545: and first_noa_code = p_first_noa_code
3546: and effective_date = p_effective_date

Line 3557: from ghr_pa_routing_history

3553: WHERE pay_plan = p_pay_plan;
3554:
3555: cursor pa_hist_cur (p_r_hist_id number) is
3556: select nvl(action_taken,' ') action_taken
3557: from ghr_pa_routing_history
3558: where pa_routing_history_id = p_r_hist_id;
3559:
3560: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3561: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';

Line 3560: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3556: select nvl(action_taken,' ') action_taken
3557: from ghr_pa_routing_history
3558: where pa_routing_history_id = p_r_hist_id;
3559:
3560: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3561: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3562: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3563:
3564: begin

Line 3701: from ghr_pa_requests pr, ghr_pa_routing_history prh

3697: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
3698:
3699: cursor csr_action_taken is
3700: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3701: from ghr_pa_requests pr, ghr_pa_routing_history prh
3702: where pr.pa_request_id = prh.pa_request_id
3703: and person_id = p_person_id
3704: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3705: and effective_date = p_effective_date

Line 3716: from ghr_pa_requests pr, ghr_pa_routing_history prh

3712: where pr.pa_request_id = l_pa_request_id;
3713:
3714: cursor csr_action_taken_fw is
3715: select pr.pa_request_id, max(pa_routing_history_id) pa_routing_history_id
3716: from ghr_pa_requests pr, ghr_pa_routing_history prh
3717: where pr.pa_request_id = prh.pa_request_id
3718: and person_id = p_person_id
3719: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3720: and effective_date = p_effective_date

Line 3731: from ghr_pa_routing_history

3727: WHERE pay_plan = p_pay_plan;
3728:
3729: cursor pa_hist_cur (p_r_hist_id number) is
3730: select nvl(action_taken,' ') action_taken
3731: from ghr_pa_routing_history
3732: where pa_routing_history_id = p_r_hist_id;
3733:
3734: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3735: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';

Line 3734: l_action_taken ghr_pa_routing_history.action_taken%TYPE;

3730: select nvl(action_taken,' ') action_taken
3731: from ghr_pa_routing_history
3732: where pa_routing_history_id = p_r_hist_id;
3733:
3734: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3735: l_proc varchar2(72) := g_package || '.person_in_pa_req_1noa';
3736: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3737:
3738: begin