DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 407: pay_run_results prr,

403: pec.classification_name,
404: piv.uom
405: from pay_element_types_f pet,
406: pay_input_values_f piv,
407: pay_run_results prr,
408: pay_element_classifications pec,
409: pay_assignment_actions paa, -- Assignment Action of Prepayments
410: pay_assignment_actions rpaa, -- Assignment Action of Run
411: pay_action_interlocks pai,

Line 1624: pay_run_results prr

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
1628: and prr.element_type_id = p_element_type_id

Line 1645: pay_run_results prr

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
1649: from pay_assignment_actions paa,