DBA Data[Home] [Help]

APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on PAY_RUN_RESULTS

Line 147: pay_run_results prr, -- run result created by the payroll run/quick pay

143: pay_assignment_actions paa, -- payroll run/quickpay action
144: pay_payroll_actions ppa1, -- payroll run/quickpay action
145: pay_element_types_f pet, -- element types processed by the payroll run/quickpay
146: pay_input_values_f piv, -- "Pay values" of type Money
147: pay_run_results prr, -- run result created by the payroll run/quick pay
148: pay_run_result_values prv -- Run Result value (Pay Value) created by the payroll run/quickpay
149: WHERE lck.locking_action_id = paa2.assignment_action_id
150: AND paa2.payroll_action_id = pai.action_context_id
151: AND pai.action_context_type = 'PA'

Line 1719: pay_run_results prr

1715: p_element_type_id NUMBER,
1716: p_input_value_id NUMBER) IS
1717: SELECT prv.result_value
1718: FROM pay_run_result_values prv,
1719: pay_run_results prr
1720: WHERE prr.status IN ('P','PA')
1721: AND prv.run_result_id = prr.run_result_id
1722: AND prr.assignment_action_id = p_assignment_action_id
1723: AND prr.element_type_id = p_element_type_id