APPS.PAY_ARCHIVE dependencies on PAY_MESSAGE_LINES

Line 1319: delete from PAY_MESSAGE_LINES

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
1320: where source_id = aalist(i)
1321: and source_type = 'A';
1322: --
1323: forall i in 1..aalist.count

Line 1336: delete from PAY_MESSAGE_LINES

1332: loop
1333: fetch objcur bulk collect into objlist limit 1000;
1334: --
1335: forall i in 1..objlist.count
1336: delete from PAY_MESSAGE_LINES
1337: where source_id = objlist(i)
1338: and source_type = 'A';
1339: --
1340: forall i in 1..objlist.count

Line 1348: delete from PAY_MESSAGE_LINES

1344: exit when objcur%notfound;
1345: end loop;
1346: close objcur;
1347: --
1348: delete from PAY_MESSAGE_LINES
1349: where source_id = p_pact_id
1350: and source_type = 'P';
1351: --
1352: delete from pay_population_ranges

Line 1368: delete from PAY_MESSAGE_LINES

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
1369: where source_id = aalist(i)
1370: and source_type = 'A';
1371: --
1372: exit when asgrescur%notfound;