DBA Data[Home] [Help]

APPS.PAY_MX_TRR_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 199: pay_assignment_actions paa

195: ,c_end_date_earned IN date ) IS
196: SELECT max(paa.assignment_action_id)
197: FROM pay_consolidation_sets pcs,
198: pay_payroll_actions ppa,
199: pay_assignment_actions paa
200: WHERE pcs.business_group_id = c_business_group_id
201: AND ppa.payroll_action_id = paa.payroll_action_id
202: AND ppa.consolidation_set_id = pcs.consolidation_set_id + 0
203: AND paa.tax_unit_id = c_tax_unit_id