APPS.HZ_PURGE dependencies on HZ_REFERENCES

Line 697: DELETE from HZ_REFERENCES where REFERENCED_PARTY_ID in

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);
696:
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

Line 699: log(' HZ_REFERENCES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

695: log(' HZ_FINANCIAL_PROFILE : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
696:
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);

Line 1007: DELETE from HZ_REFERENCES where REFERENCED_PARTY_ID = p_party_id;

1003: DELETE from HZ_PERSON_PROFILES where PARTY_ID = p_party_id;
1004:
1005: DELETE from HZ_FINANCIAL_PROFILE where PARTY_ID = p_party_id;
1006:
1007: DELETE from HZ_REFERENCES where REFERENCED_PARTY_ID = p_party_id;
1008:
1009: DELETE from HZ_CERTIFICATIONS where PARTY_ID = p_party_id;
1010:
1011: DELETE from HZ_CREDIT_RATINGS where PARTY_ID = p_party_id;