APPS.HZ_PURGE_GEN dependencies on HZ_WORK_CLASS

Line 3010: --HZ_WORK_CLASS;EMPLOYMENT_HISTORY_ID

3006: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
3007: yy
3008: ));
3009: end if;
3010: --HZ_WORK_CLASS;EMPLOYMENT_HISTORY_ID
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:

Line 3019: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

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
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

Line 3026: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

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
3027: yy
3028: where nvl(STATUS, 'A') in ('A','I')));
3029: else
3030: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3035: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

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
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

Line 3042: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

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
3043: yy
3044: where nvl(STATUS, 'A') in ('A','I')));
3045: end if;
3046: --FND_ATTACHED_DOCUMENTS;PK1_VALUE