DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on HZ_ORGANIZATION_INDICATORS

Line 717: DELETE from HZ_ORGANIZATION_INDICATORS where PARTY_ID in

713: log(' HZ_FINANCIAL_NUMBERS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
714: DELETE from HZ_FINANCIAL_REPORTS where PARTY_ID in
715: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
716: log(' HZ_FINANCIAL_REPORTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
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

Line 1020: DELETE from HZ_ORGANIZATION_INDICATORS where PARTY_ID = p_party_id;

1016: ( select FINANCIAL_REPORT_ID FROM HZ_FINANCIAL_REPORTS WHERE PARTY_ID = p_party_id);
1017:
1018: DELETE from HZ_FINANCIAL_REPORTS where PARTY_ID = p_party_id;
1019:
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;