DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 304: FROM pay_assignment_actions paa,

300: -- Payroll
301: --
302: CURSOR lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
303: SELECT paa.assignment_action_id
304: FROM pay_assignment_actions paa,
305: ce_statement_reconcils_all rec
306: WHERE paa.rowid = trx_rowid
307: AND rec.reference_id(+) = paa.assignment_action_id
308: AND rec.reference_type(+) = 'PAY'

Line 318: FROM pay_assignment_actions paa

314: -- Payroll line clearing
315: --
316: CURSOR clear_lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
317: SELECT paa.assignment_action_id
318: FROM pay_assignment_actions paa
319: WHERE paa.rowid = trx_rowid
320: FOR UPDATE OF paa.assignment_action_id NOWAIT;
321:
322: --