APPS.HZ_PURGE_GEN dependencies on AS_CURRENT_ENVIRONMENT

Line 1285: (select 'Y' from AS_CURRENT_ENVIRONMENT

1281: or exists (select 'Y' from HZ_PARTY_SITES
1282: xx where xx.PARTY_ID = temp.party_id
1283: and (nvl(STATUS, 'A') in ('A','I'))
1284: and exists
1285: (select 'Y' from AS_CURRENT_ENVIRONMENT
1286: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1287: ))
1288:
1289: or exists (select 'Y' from HZ_PARTY_SITES

Line 1604: (select 'Y' from AS_CURRENT_ENVIRONMENT

1600: or exists (select 'Y' from HZ_PARTY_SITES
1601: xx where xx.PARTY_ID = temp.party_id
1602: and (nvl(STATUS, 'A') in ('A','I'))
1603: and exists
1604: (select 'Y' from AS_CURRENT_ENVIRONMENT
1605: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
1606: ))
1607:
1608: or exists (select 'Y' from HZ_PARTY_SITES

Line 4008: --AS_CURRENT_ENVIRONMENT;CUSTOMER_ID

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;
4010: if(regid_proc = true) then
4011: 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
4012:

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

4009: appid:=279;
4010: if(regid_proc = true) then
4011: 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
4012:
4013: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx
4014: );
4015: else
4016: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4017: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx

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

4013: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx
4014: );
4015: else
4016: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4017: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx
4018: );
4019: end if;
4020: --AS_SALES_LEADS;REFERRED_BY
4021: appid:=279;