DBA Data[Home] [Help]

APPS.HZ_PURGE dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 584: DELETE from HZ_PARTY_USG_ASSIGNMENTS where PARTY_ID in

580: close printparties;
581:
582: hz_common_pub.disable_cont_source_security;
583: --4307686
584: DELETE from HZ_PARTY_USG_ASSIGNMENTS where PARTY_ID in
585: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
586: log(' HZ_PARTY_USG_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
587:
588: DELETE from HZ_ORGANIZATION_PROFILES where PARTY_ID in

Line 586: log(' HZ_PARTY_USG_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

582: hz_common_pub.disable_cont_source_security;
583: --4307686
584: DELETE from HZ_PARTY_USG_ASSIGNMENTS where PARTY_ID in
585: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
586: log(' HZ_PARTY_USG_ASSIGNMENTS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
587:
588: DELETE from HZ_ORGANIZATION_PROFILES where PARTY_ID in
589: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
590: log(' HZ_ORGANIZATION_PROFILES : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);