APPS.HZ_PURGE_GEN dependencies on OKL_LEASE_APPS_ALL_B

Line 1900: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id

1896: and nvl(STATUS, 'A') in ('A','I')
1897: and exists
1898: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
1899:
1900: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1901: )
1902:
1903: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1904: )

Line 1977: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id

1973: and nvl(STATUS, 'A') in ('A','I')
1974: and exists
1975: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
1976:
1977: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1978: )
1979:
1980: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1981: )

Line 4600: --OKL_LEASE_APPS_ALL_B;PROSPECT_ADDRESS_ID

4596: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4597: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_REL_ID2_OLD from OKL_TRX_CONTRACTS_ALL xx
4598: );
4599: end if;
4600: --OKL_LEASE_APPS_ALL_B;PROSPECT_ADDRESS_ID
4601: appid:=540;
4602: if(regid_proc = true) then
4603: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4604:

Line 4609: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B

4605: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4606: xx
4607: where (nvl(STATUS, 'A') in ('A','I'))
4608: and xx.PARTY_SITE_ID
4609: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B
4610: yy
4611: ));
4612: else
4613: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4618: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B

4614: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4615: xx
4616: where (nvl(STATUS, 'A') in ('A','I'))
4617: and xx.PARTY_SITE_ID
4618: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_APPS_ALL_B
4619: yy
4620: ));
4621: end if;
4622: --OKL_LEASE_OPPS_ALL_B;PROSPECT_ADDRESS_ID