APPS.GHR_MSL_PKG dependencies on GHR_HISTORY_API

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

3725: where pr.pa_request_id = prh.pa_request_id
3726: and person_id = p_person_id
3727: and first_noa_code = p_first_noa_code
3728: and effective_date = p_effective_date
3729: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3730: ---- Bug # 657439
3731: --and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
3732: group by pr.pa_request_id;
3733:

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

3744: where pr.pa_request_id = prh.pa_request_id
3745: and person_id = p_person_id
3746: and first_noa_code = p_first_noa_code
3747: and effective_date = p_effective_date
3748: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3749: group by pr.pa_request_id;
3750:
3751: cursor csr_eq_pay_plan is
3752: SELECT equivalent_pay_plan

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

3860: where pr.pa_request_id = prh.pa_request_id
3861: and nvl(person_id,0) = p_person_id
3862: and nvl(second_noa_code,0) = p_second_noa_code
3863: and nvl(effective_date,trunc(sysdate)) >= (p_effective_date-p_days)
3864: and nvl(pr.second_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3865: --Bug 657439
3866: -- and nvl(pr.second_noa_cancel_or_correct,'X') <> 'CANCELED'
3867: group by pr.pa_request_id;
3868: