APPS.HZ_PURGE dependencies on HZ_PERSON_PROFILES

Line 689: DELETE from HZ_PERSON_PROFILES where PARTY_ID in

685: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED')
686: and OWNER_TABLE_NAME='HZ_PARTIES';
687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
688:
689: DELETE from HZ_PERSON_PROFILES where PARTY_ID in
690: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
691: log(' HZ_PERSON_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
692:
693: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID in

Line 691: log(' HZ_PERSON_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

687: log(' HZ_CONTACT_POINTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
688:
689: DELETE from HZ_PERSON_PROFILES where PARTY_ID in
690: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
691: log(' HZ_PERSON_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
692:
693: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID in
694: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
695: log(' HZ_FINANCIAL_PROFILE : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

Line 991: DELETE from HZ_PERSON_PROFILES where PARTY_ID = p_party_id;

987: end;
988:
989: DELETE from HZ_CONTACT_POINTS where OWNER_TABLE_ID = p_party_id and OWNER_TABLE_NAME='HZ_PARTIES';
990:
991: DELETE from HZ_PERSON_PROFILES where PARTY_ID = p_party_id;
992:
993: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID = p_party_id;
994:
995: DELETE from HZ_REFERENCES where REFERENCED_PARTY_ID = p_party_id;