APPS.HZ_PURGE_GEN dependencies on HZ_CODE_ASSIGNMENTS

Line 2980: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID

2976: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2977: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx
2978: );
2979: end if;
2980: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID
2981: appid:=222;
2982: if(regid_proc = true) then
2983: 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
2984:

Line 2985: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx

2981: appid:=222;
2982: if(regid_proc = true) then
2983: 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
2984:
2985: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx
2986: where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));
2987: else
2988: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2989: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx

Line 2989: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx

2985: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx
2986: where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));
2987: else
2988: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2989: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx
2990: where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));
2991: end if;
2992: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID
2993: appid:=222;

Line 2992: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID

2988: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2989: temp.party_id in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx
2990: where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));
2991: end if;
2992: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID
2993: appid:=222;
2994: if(regid_proc = true) then
2995: 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
2996:

Line 3001: in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS

2997: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
2998: xx
2999: where (nvl(STATUS, 'A') in ('A','I'))
3000: and xx.PARTY_SITE_ID
3001: in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS
3002: yy
3003: where OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')));
3004: else
3005: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3010: in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS

3006: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3007: xx
3008: where (nvl(STATUS, 'A') in ('A','I'))
3009: and xx.PARTY_SITE_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