DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_RUN_RESULTS

Line 617: FROM pay_run_results prr

613: AND past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN');
614:
615: CURSOR csr_max_run_result(p_assignment_action_id number,p_element_id number) IS
616: SELECT max(prr.RUN_RESULT_ID)
617: FROM pay_run_results prr
618: WHERE prr.ASSIGNMENT_ACTION_ID = p_assignment_action_id
619: AND prr.ELEMENT_TYPE_ID = p_element_id
620: AND prr.status in ('P','PA');
621: