DBA Data[Home] [Help]

APPS.PAY_US_OVER_LIMIT_PKG dependencies on PAY_ACTION_CLASSIFICATIONS

Line 247: pay_action_classifications pac

243: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id -- Bug 5717518
244: from per_all_assignments_f paf,
245: pay_assignment_actions paa,
246: pay_payroll_actions ppa,
247: pay_action_classifications pac
248: where paf.assignment_id = cp_assignid -- Bug 5717518: New parameter added for performance improvement
249: and paf.person_id = cp_person_id -- Bug 5717518: Shuffled the Where Clause for performance improvement
250: and paa.assignment_id = paf.assignment_id
251: and paa.tax_unit_id = cp_tax_unit_id