APPS.GHR_MSL_PKG dependencies on GHR_HISTORY_API

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

3689: where pr.pa_request_id = prh.pa_request_id
3690: and person_id = p_person_id
3691: and first_noa_code = p_first_noa_code
3692: and effective_date = p_effective_date
3693: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3694: ---- Bug # 657439
3695: --and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
3696: group by pr.pa_request_id;
3697:

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

3708: where pr.pa_request_id = prh.pa_request_id
3709: and person_id = p_person_id
3710: and first_noa_code = p_first_noa_code
3711: and effective_date = p_effective_date
3712: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3713: group by pr.pa_request_id;
3714:
3715: cursor csr_eq_pay_plan is
3716: SELECT equivalent_pay_plan

Line 3812: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel

3808: where pr.pa_request_id = prh.pa_request_id
3809: and nvl(person_id,0) = p_person_id
3810: and nvl(second_noa_code,0) = p_second_noa_code
3811: and nvl(effective_date,trunc(sysdate)) >= (p_effective_date-p_days)
3812: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3813: --Bug 657439
3814: -- and nvl(pr.second_noa_cancel_or_correct,'X') <> 'CANCELED'
3815: group by pr.pa_request_id;
3816: