DBA Data[Home] [Help]

APPS.PAY_KR_BATCH_YEA_PKG dependencies on PAY_ACTION_CLASSIFICATIONS

Line 136: pay_action_classifications pac

132: use_nl(ppa2)
133: */ null
134: from pay_assignment_actions paa2,
135: pay_payroll_actions ppa2,
136: pay_action_classifications pac
137: where paa2.assignment_id = asg.assignment_id
138: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
139: and paa2.source_action_id is null
140: and ppa2.payroll_action_id = paa2.payroll_action_id

Line 249: pay_action_classifications pac

245: use_nl(ppa2)
246: */ null
247: from pay_assignment_actions paa2,
248: pay_payroll_actions ppa2,
249: pay_action_classifications pac
250: where paa2.assignment_id = asg.assignment_id
251: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
252: and paa2.source_action_id is null
253: and ppa2.payroll_action_id = paa2.payroll_action_id