APPS.HZ_PURGE_GEN dependencies on HZ_WORK_CLASS

Line 3014: --HZ_WORK_CLASS;EMPLOYMENT_HISTORY_ID

3010: in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS
3011: yy
3012: where OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')));
3013: end if;
3014: --HZ_WORK_CLASS;EMPLOYMENT_HISTORY_ID
3015: appid:=222;
3016: if(regid_proc = true) then
3017: 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
3018:

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

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

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

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

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

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

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

3042: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
3043: xx
3044: where (nvl(STATUS,'A') in ('A','I'))
3045: and xx.EMPLOYMENT_HISTORY_ID
3046: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3047: yy
3048: where nvl(STATUS, 'A') in ('A','I')));
3049: end if;
3050: --FND_ATTACHED_DOCUMENTS;PK1_VALUE