APPS.HZ_PURGE dependencies on HZ_CERTIFICATIONS

Line 701: DELETE from HZ_CERTIFICATIONS where PARTY_ID in

697: DELETE from HZ_REFERENCES where REFERENCED_PARTY_ID in
698: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
699: log(' HZ_REFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
700:
701: DELETE from HZ_CERTIFICATIONS where PARTY_ID in
702: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
703: log(' HZ_CERTIFICATIONS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
704: DELETE from HZ_CREDIT_RATINGS where PARTY_ID in
705: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');

Line 703: log(' HZ_CERTIFICATIONS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

699: log(' HZ_REFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
700:
701: DELETE from HZ_CERTIFICATIONS where PARTY_ID in
702: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
703: log(' HZ_CERTIFICATIONS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
704: DELETE from HZ_CREDIT_RATINGS where PARTY_ID in
705: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
706: log(' HZ_CREDIT_RATINGS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
707: DELETE from HZ_SECURITY_ISSUED where PARTY_ID in

Line 997: DELETE from HZ_CERTIFICATIONS where PARTY_ID = p_party_id;

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;
996:
997: DELETE from HZ_CERTIFICATIONS where PARTY_ID = p_party_id;
998:
999: DELETE from HZ_CREDIT_RATINGS where PARTY_ID = p_party_id;
1000:
1001: DELETE from HZ_SECURITY_ISSUED where PARTY_ID = p_party_id;