DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULT_VALUES

Line 1623: from pay_run_result_values prv,

1619: p_element_type_id number,
1620: p_input_value_id number
1621: ) is
1622: select prv.result_value result_value /* Modified for Bug#10242073 */
1623: from pay_run_result_values prv,
1624: pay_run_results prr
1625: where prr.status in ('P', 'PA')
1626: and prv.run_result_id = prr.run_result_id
1627: and prr.assignment_action_id = p_assignment_action_id

Line 1644: from pay_run_result_values prv,

1640: p_element_type_id number,
1641: p_input_value_id number
1642: ) is
1643: select nvl(sum(fnd_number.canonical_to_number(prv.result_value)),0) result_value
1644: from pay_run_result_values prv,
1645: pay_run_results prr
1646: where prr.status in ('P', 'PA')
1647: and prv.run_result_id = prr.run_result_id
1648: and prr.assignment_action_id in (select paa.assignment_action_id