DBA Data[Home] [Help]

APPS.PAY_CC_PROCESS_UTILS dependencies on PAY_ACTION_CLASSIFICATIONS

Line 213: from pay_action_classifications acl,

209: and pai2.locked_action_id = paa2.assignment_action_id
210: )
211: and not exists (
212: select null
213: from pay_action_classifications acl,
214: pay_payroll_actions pa2,
215: pay_assignment_actions ac2
216: where ac2.assignment_id = paa.assignment_id
217: and pa2.payroll_action_id = ac2.payroll_action_id

Line 225: from pay_action_classifications acl,

221: and ac2.action_sequence > paa.action_sequence
222: )
223: and not exists (
224: select null
225: from pay_action_classifications acl,
226: pay_payroll_actions pa2,
227: pay_assignment_actions ac2
228: where ac2.assignment_id = paa.assignment_id
229: and pa2.payroll_action_id = ac2.payroll_action_id

Line 298: from pay_action_classifications acl,

294: and pai2.locked_action_id = paa2.assignment_action_id
295: )
296: and not exists (
297: select 1
298: from pay_action_classifications acl,
299: pay_payroll_actions pa2,
300: pay_assignment_actions ac2
301: where ac2.assignment_id = paa.assignment_id
302: and pa2.payroll_action_id = ac2.payroll_action_id