APPS.HZ_PURGE dependencies on HZ_CITIZENSHIP

Line 725: DELETE from HZ_CITIZENSHIP where PARTY_ID in

721: DELETE from HZ_PERSON_INTEREST where PARTY_ID in
722: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
723: log(' HZ_FINANCIAL_REPORTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
724:
725: DELETE from HZ_CITIZENSHIP where PARTY_ID in
726: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
727: log(' HZ_FINANCIAL_REPORTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
728:
729: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in

Line 1024: DELETE from HZ_CITIZENSHIP where PARTY_ID = p_party_id;

1020: DELETE from HZ_ORGANIZATION_INDICATORS where PARTY_ID = p_party_id;
1021:
1022: DELETE from HZ_PERSON_INTEREST where PARTY_ID = p_party_id;
1023:
1024: DELETE from HZ_CITIZENSHIP where PARTY_ID = p_party_id;
1025:
1026: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in
1027: (select EMPLOYMENT_HISTORY_ID FROM HZ_EMPLOYMENT_HISTORY WHERE PARTY_ID = p_party_id);
1028: