APPS.HZ_PURGE_GEN dependencies on OZF_ACTIVITY_CUSTOMERS

Line 3394: --OZF_ACTIVITY_CUSTOMERS;PARTY_ID

3390: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3391: temp.party_id in (select /*+ parallel(xx)*/ xx.AUTOPAY_PARTY_ID from OZF_OFFERS xx
3392: );
3393: end if;
3394: --OZF_ACTIVITY_CUSTOMERS;PARTY_ID
3395: appid:=682;
3396: if(regid_proc = true) then
3397: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3398:

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

3395: appid:=682;
3396: if(regid_proc = true) then
3397: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3398:
3399: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx
3400: );
3401: else
3402: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3403: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx

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

3399: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx
3400: );
3401: else
3402: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3403: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx
3404: );
3405: end if;
3406: --OZF_CLAIM_LINES_HIST_ALL;BUY_GROUP_PARTY_ID
3407: appid:=682;