APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 1498: pay_run_results prr

1494: p_element_type_id NUMBER,
1495: p_input_value_id NUMBER) IS
1496: SELECT prv.result_value
1497: FROM pay_run_result_values prv,
1498: pay_run_results prr
1499: WHERE prr.status IN ('P','PA')
1500: AND prv.run_result_id = prr.run_result_id
1501: AND prr.assignment_action_id = p_assignment_action_id
1502: AND prr.element_type_id = p_element_type_id