eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MLC_PKG dependencies on GHR_HISTORY_API

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

3572: where pr.pa_request_id = prh.pa_request_id
3573: and person_id = p_person_id
3574: and first_noa_code = p_first_noa_code
3575: and effective_date = p_effective_date
3576: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3577: ---- Bug # 657439
3578: --and nvl(pr.first_noa_cancel_or_correct,'X') <> 'CANCELED'
3579: group by pr.pa_request_id;
3580:

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

3589: where pr.pa_request_id = prh.pa_request_id
3590: and person_id = p_person_id
3591: and first_noa_code = p_first_noa_code
3592: and effective_date = p_effective_date
3593: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3594: group by pr.pa_request_id;
3595:
3596: cursor csr_eq_pay_plan is
3597: SELECT equivalent_pay_plan

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

3748: where pr.pa_request_id = prh.pa_request_id
3749: and person_id = p_person_id
3750: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3751: and effective_date = p_effective_date
3752: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3753: group by pr.pa_request_id;
3754:
3755: cursor csr_name is
3756: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname

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

3763: where pr.pa_request_id = prh.pa_request_id
3764: and person_id = p_person_id
3765: and (first_noa_code = p_first_noa_code or first_noa_code = '800')
3766: and effective_date = p_effective_date
3767: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
3768: group by pr.pa_request_id;
3769:
3770: cursor csr_eq_pay_plan is
3771: SELECT equivalent_pay_plan

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

5516: where pr.pa_request_id = prh.pa_request_id
5517: and person_id = p_person_id
5518: and first_noa_code = p_first_noa_code
5519: and effective_date = p_effective_date
5520: and nvl(pr.first_noa_cancel_or_correct,'X') <> ghr_history_api.g_cancel
5521: group by pr.pa_request_id;
5522:
5523: cursor csr_name is
5524: select substr(pr.employee_last_name || ', ' || pr.employee_first_name,1,240) fname