DBA Data[Home] [Help]

APPS.PAY_BALANCE_ADJUSTMENT_API dependencies on PAY_ASSIGNMENT_ACTIONS

Line 312: pay_assignment_actions act,

308: ,act.assignment_action_id
309: into l_payroll_action_id
310: ,l_assignment_action_id
311: from pay_payroll_actions ppa,
312: pay_assignment_actions act,
313: pay_element_entries_f pee
314: where pee.element_entry_id = p_element_entry_id
315: and pee.entry_type = 'B'
316: and p_effective_date between

Line 333: (select 1 from pay_assignment_actions paa

329:
330: select 1 into l_dummy from dual
331: where
332: not exists
333: (select 1 from pay_assignment_actions paa
334: where paa.payroll_action_id = l_payroll_action_id
335: and paa.assignment_action_id <> l_assignment_action_id)
336: and not exists
337: (select 1 from pay_run_results prr