APPS.GHR_MLC_PKG dependencies on GHR_HISTORY_API

Line 3530: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

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
3530: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3531: ---- Bug # 657439
3532: --and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
3533: group by pr.pa_request_id;
3534:

Line 3547: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

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
3547: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3548: group by pr.pa_request_id;
3549:
3550: cursor csr_eq_pay_plan is
3551: SELECT equivalent_pay_plan

Line 3706: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

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
3706: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3707: group by pr.pa_request_id;
3708:
3709: cursor csr_name is
3710: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname

Line 3721: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

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
3721: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3722: group by pr.pa_request_id;
3723:
3724: cursor csr_eq_pay_plan is
3725: SELECT equivalent_pay_plan