APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1497: FROM pay_run_result_values prv,

1493: CURSOR csr_element_values (p_assignment_action_id NUMBER,
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

Line 1515: l_result_value pay_run_result_values.result_value%TYPE;

1511: l_ovn NUMBER;
1512: l_record_count VARCHAR2(10);
1513:
1514: -- Added for bug 5387406
1515: l_result_value pay_run_result_values.result_value%TYPE;
1516:
1517:
1518: BEGIN
1519: