APPS.HZ_PURGE dependencies on HZ_PARTY_SITE_USES

Line 636: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in

632: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
633: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
634: log(' HZ_ORG_CONTACTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
635:
636: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in
637: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
638: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
639: log(' HZ_PARTY_SITE_USES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
640:

Line 639: log(' HZ_PARTY_SITE_USES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

635:
636: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in
637: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
638: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
639: log(' HZ_PARTY_SITE_USES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
640:
641: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
642: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
643: (select candidate_party_id from hz_purge_candidates where batch_id=:1 and status=''IDENTIFIED''))

Line 970: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in

966:
967: DELETE from HZ_ORG_CONTACTS where PARTY_SITE_ID in
968: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id);
969:
970: DELETE from HZ_PARTY_SITE_USES where PARTY_SITE_ID in
971: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id);
972:
973: execute immediate 'DELETE from HZ_CODE_ASSIGNMENTS where OWNER_TABLE_ID in
974: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = :1) and OWNER_TABLE_NAME=''HZ_PARTY_SITES''' using p_party_id;