APPS.HZ_PURGE_GEN dependencies on HZ_EMPLOYMENT_HISTORY

Line 3015: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY

3011: appid:=222;
3012: if(regid_proc = true) then
3013: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3014:
3015: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
3016: xx
3017: where (nvl(STATUS, 'A') in ('A','I'))
3018: and xx.EMPLOYMENT_HISTORY_ID
3019: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

Line 3022: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY

3018: and xx.EMPLOYMENT_HISTORY_ID
3019: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3020: yy
3021: where nvl(STATUS, 'A') in ('A','I')))
3022: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
3023: xx
3024: where (nvl(STATUS,'A') in ('A','I'))
3025: and xx.EMPLOYMENT_HISTORY_ID
3026: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

Line 3031: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY

3027: yy
3028: where nvl(STATUS, 'A') in ('A','I')));
3029: else
3030: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3031: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
3032: xx
3033: where (nvl(STATUS, 'A') in ('A','I'))
3034: and xx.EMPLOYMENT_HISTORY_ID
3035: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

Line 3038: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY

3034: and xx.EMPLOYMENT_HISTORY_ID
3035: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3036: yy
3037: where nvl(STATUS, 'A') in ('A','I')))
3038: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
3039: xx
3040: where (nvl(STATUS,'A') in ('A','I'))
3041: and xx.EMPLOYMENT_HISTORY_ID
3042: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS