APPS.GHR_CPDF_EHRIS dependencies on GHR_PA_REQUESTS

Line 1488: and pa_request_id = (select max(pa_request_id) from ghr_pa_requests

1484: is
1485: select rei_information2
1486: from ghr_pa_request_extra_info
1487: where information_type = 'GHR_US_PAR_FEGLI'
1488: and pa_request_id = (select max(pa_request_id) from ghr_pa_requests
1489: where pa_notification_id is not null
1490: start with pa_request_id = (select max(pa_request_id) from ghr_pa_requests A
1491: where pa_notification_id is not null
1492: and first_noa_code = '881'

Line 1490: start with pa_request_id = (select max(pa_request_id) from ghr_pa_requests A

1486: from ghr_pa_request_extra_info
1487: where information_type = 'GHR_US_PAR_FEGLI'
1488: and pa_request_id = (select max(pa_request_id) from ghr_pa_requests
1489: where pa_notification_id is not null
1490: start with pa_request_id = (select max(pa_request_id) from ghr_pa_requests A
1491: where pa_notification_id is not null
1492: and first_noa_code = '881'
1493: and employee_assignment_id = p_sr_assignment_id
1494: and effective_date = p_effective_date

Line 1495: and not exists( select 1 from ghr_pa_requests

1491: where pa_notification_id is not null
1492: and first_noa_code = '881'
1493: and employee_assignment_id = p_sr_assignment_id
1494: and effective_date = p_effective_date
1495: and not exists( select 1 from ghr_pa_requests
1496: where altered_pa_request_id = A.pa_request_id
1497: and pa_notification_id is not null
1498: and first_noa_code = '001'))
1499: connect by altered_pa_request_id = prior pa_request_id);

Line 3418: FROM ghr_pa_requests

3414: --Bug# 6477035
3415: /*Cursor nte_date
3416: is
3417: SELECT first_noa_information1
3418: FROM ghr_pa_requests
3419: WHERE employee_assignment_id = g_assignment_id
3420: AND pa_notification_id is not null
3421: AND person_id = g_person_id
3422: AND to_position_id = g_position_id