DBA Data[Home] [Help]

APPS.PAY_ARCHIVE dependencies on PAY_ACTION_INTERLOCKS

Line 1315: delete from pay_action_interlocks

1311: loop
1312: fetch asgcur bulk collect into aalist limit 1000;
1313: --
1314: forall i in 1..aalist.count
1315: delete from pay_action_interlocks
1316: where locking_action_id = aalist(i);
1317: --
1318: forall i in 1..aalist.count
1319: delete from PAY_MESSAGE_LINES

Line 1364: delete from pay_action_interlocks

1360: loop
1361: fetch asgrescur bulk collect into aalist limit 1000;
1362: --
1363: forall i in 1..aalist.count
1364: delete from pay_action_interlocks
1365: where locking_action_id = aalist(i);
1366: --
1367: forall i in 1..aalist.count
1368: delete from PAY_MESSAGE_LINES