DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 396: pay_run_results prr,

392: pec.classification_name,
393: piv.uom
394: from pay_element_types_f pet,
395: pay_input_values_f piv,
396: pay_run_results prr,
397: pay_element_classifications pec,
398: pay_assignment_actions paa, -- Assignment Action of Prepayments
399: pay_assignment_actions rpaa, -- Assignment Action of Run
400: pay_action_interlocks pai,

Line 1489: pay_run_results prr

1485: p_input_value_id number
1486: ) is
1487: select prv.result_value
1488: from pay_run_result_values prv,
1489: pay_run_results prr
1490: where prr.status in ('P', 'PA')
1491: and prv.run_result_id = prr.run_result_id
1492: and prr.assignment_action_id = p_assignment_action_id
1493: and prr.element_type_id = p_element_type_id