DBA Data[Home] [Help]

APPS.CE_AUTO_BANK_MATCH dependencies on PAY_ASSIGNMENT_ACTIONS

Line 285: FROM pay_assignment_actions paa,

281: -- Payroll
282: --
283: CURSOR lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
284: SELECT paa.assignment_action_id
285: FROM pay_assignment_actions paa,
286: ce_statement_reconcils_all rec
287: WHERE paa.rowid = trx_rowid
288: AND rec.reference_id(+) = paa.assignment_action_id
289: AND rec.reference_type(+) = 'PAY'

Line 299: FROM pay_assignment_actions paa

295: -- Payroll line clearing
296: --
297: CURSOR clear_lock_801 (X_call_mode VARCHAR2,trx_rowid VARCHAR2) IS
298: SELECT paa.assignment_action_id
299: FROM pay_assignment_actions paa
300: WHERE paa.rowid = trx_rowid
301: FOR UPDATE OF paa.assignment_action_id NOWAIT;
302:
303: --