APPS.HZ_PURGE dependencies on HZ_ORG_CONTACT_ROLES

Line 614: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in

610: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
611: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')) and OWNER_TABLE_NAME='HZ_PARTY_SITES';
612: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
613:
614: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in
615: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in (
616: SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
617: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')));
618: log(' HZ_ORG_CONTACT_ROLES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 618: log(' HZ_ORG_CONTACT_ROLES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

614: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in
615: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in (
616: SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID in
617: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')));
618: log(' HZ_ORG_CONTACT_ROLES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
619:
620: begin
621: execute immediate 'DELETE from HZ_STAGED_CONTACTS where ORG_CONTACT_ID in
622: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in

Line 954: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in

950:
951: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID in
952: ( select PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id) and OWNER_TABLE_NAME='HZ_PARTY_SITES';
953:
954: DELETE from HZ_ORG_CONTACT_ROLES where ORG_CONTACT_ID in
955: ( select ORG_CONTACT_ID FROM HZ_ORG_CONTACTS WHERE PARTY_SITE_ID in (
956: SELECT PARTY_SITE_ID FROM HZ_PARTY_SITES WHERE PARTY_ID = p_party_id));
957:
958: begin