APPS.HZ_PURGE_GEN dependencies on AS_LEADS_LOG

Line 3962: --AS_LEADS_LOG;CUSTOMER_ID

3958: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3959: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx
3960: );
3961: end if;
3962: --AS_LEADS_LOG;CUSTOMER_ID
3963: appid:=279;
3964: if(regid_proc = true) then
3965: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3966:

Line 3967: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx

3963: appid:=279;
3964: if(regid_proc = true) then
3965: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3966:
3967: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx
3968: );
3969: else
3970: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3971: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx

Line 3971: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx

3967: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx
3968: );
3969: else
3970: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3971: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx
3972: );
3973: end if;
3974: --AS_LEADS_LOG;ADDRESS_ID
3975: appid:=279;

Line 3974: --AS_LEADS_LOG;ADDRESS_ID

3970: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3971: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx
3972: );
3973: end if;
3974: --AS_LEADS_LOG;ADDRESS_ID
3975: appid:=279;
3976: if(regid_proc = true) then
3977: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
3978:

Line 3983: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG

3979: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3980: xx
3981: where (nvl(STATUS, 'A') in ('A','I'))
3982: and xx.PARTY_SITE_ID
3983: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG
3984: yy
3985: ));
3986: else
3987: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3992: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG

3988: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3989: xx
3990: where (nvl(STATUS, 'A') in ('A','I'))
3991: and xx.PARTY_SITE_ID
3992: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG
3993: yy
3994: ));
3995: end if;
3996: --AS_LEADS_LOG;CLOSE_COMPETITOR_ID

Line 3996: --AS_LEADS_LOG;CLOSE_COMPETITOR_ID

3992: in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG
3993: yy
3994: ));
3995: end if;
3996: --AS_LEADS_LOG;CLOSE_COMPETITOR_ID
3997: appid:=279;
3998: if(regid_proc = true) then
3999: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
4000:

Line 4001: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx

3997: appid:=279;
3998: if(regid_proc = true) then
3999: insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and
4000:
4001: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx
4002: );
4003: else
4004: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4005: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx

Line 4005: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx

4001: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx
4002: );
4003: else
4004: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4005: temp.party_id in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx
4006: );
4007: end if;
4008: --AS_CURRENT_ENVIRONMENT;CUSTOMER_ID
4009: appid:=279;