DBA Data[Home] [Help]

APPS.GHR_CPDF_EHRIS dependencies on GHR_PA_REQUEST_EXTRA_INFO

Line 1486: from ghr_pa_request_extra_info

1482: --Bug # 12958556 modified the cursor to consider the cancellation of base action
1483: cursor get_life_event_change(p_effective_date in date)
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