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'
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: --