DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on HZ_PERSON_INTEREST

Line 721: DELETE from HZ_PERSON_INTEREST where PARTY_ID in

717: DELETE from HZ_ORGANIZATION_INDICATORS where PARTY_ID in
718: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
719: log(' HZ_FINANCIAL_REPORTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
720:
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

Line 1010: DELETE from HZ_PERSON_INTEREST where PARTY_ID = p_party_id;

1006: DELETE from HZ_FINANCIAL_REPORTS where PARTY_ID = p_party_id;
1007:
1008: DELETE from HZ_ORGANIZATION_INDICATORS where PARTY_ID = p_party_id;
1009:
1010: DELETE from HZ_PERSON_INTEREST where PARTY_ID = p_party_id;
1011:
1012: DELETE from HZ_CITIZENSHIP where PARTY_ID = p_party_id;
1013:
1014: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in