APPS.HZ_PURGE_GEN dependencies on FUN_TRX_HEADERS

Line 3478: --FUN_TRX_HEADERS;RECIPIENT_ID

3474: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3475: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3476: );
3477: end if;
3478: --FUN_TRX_HEADERS;RECIPIENT_ID
3479: appid:=435;
3480: if(regid_proc = true) then
3481: 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
3482:

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

3479: appid:=435;
3480: if(regid_proc = true) then
3481: 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
3482:
3483: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx
3484: );
3485: else
3486: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3487: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx

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

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