APPS.HZ_PURGE dependencies on HZ_WORK_CLASS

Line 729: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in

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
730: (select EMPLOYMENT_HISTORY_ID FROM HZ_EMPLOYMENT_HISTORY WHERE PARTY_ID in
731: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
732: log(' HZ_WORK_CLASS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
733: DELETE from HZ_EMPLOYMENT_HISTORY where PARTY_ID in

Line 732: log(' HZ_WORK_CLASS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);

728:
729: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in
730: (select EMPLOYMENT_HISTORY_ID FROM HZ_EMPLOYMENT_HISTORY WHERE PARTY_ID in
731: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED'));
732: log(' HZ_WORK_CLASS : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
733: DELETE from HZ_EMPLOYMENT_HISTORY where PARTY_ID in
734: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
735: log(' HZ_EMPLOYMENT_HISTORY : Deleted '||SQL%ROWCOUNT||' rows',conc_prg);
736: DELETE from HZ_PERSON_LANGUAGE where PARTY_ID in

Line 1014: DELETE from HZ_WORK_CLASS where EMPLOYMENT_HISTORY_ID in

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