APPS.HZ_PURGE_GEN dependencies on FUN_TRX_HEADERS

Line 3482: --FUN_TRX_HEADERS;RECIPIENT_ID

3478: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3479: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3480: );
3481: end if;
3482: --FUN_TRX_HEADERS;RECIPIENT_ID
3483: appid:=435;
3484: if(regid_proc = true) then
3485: insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and
3486:

Line 3487: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx

3483: appid:=435;
3484: if(regid_proc = true) then
3485: insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and
3486:
3487: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx
3488: );
3489: else
3490: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3491: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx

Line 3491: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx

3487: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx
3488: );
3489: else
3490: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3491: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx
3492: );
3493: end if;
3494: --FUN_DIST_LINES;PARTY_ID
3495: appid:=435;