APPS.HZ_PURGE_GEN dependencies on OKL_LEASE_OPPS_ALL_B

Line 1903: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_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: )
1905:
1906: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1907: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))

Line 1980: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_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: )
1982:
1983: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1984: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))

Line 4622: --OKL_LEASE_OPPS_ALL_B;PROSPECT_ADDRESS_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
4623: appid:=540;
4624: if(regid_proc = true) then
4625: 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
4626:

Line 4631: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B

4627: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4628: xx
4629: where (nvl(STATUS, 'A') in ('A','I'))
4630: and xx.PARTY_SITE_ID
4631: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B
4632: yy
4633: ));
4634: else
4635: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 4640: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B

4636: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
4637: xx
4638: where (nvl(STATUS, 'A') in ('A','I'))
4639: and xx.PARTY_SITE_ID
4640: in (select /*+ parallel(yy)*/ yy.PROSPECT_ADDRESS_ID from OKL_LEASE_OPPS_ALL_B
4641: yy
4642: ));
4643: end if;
4644: --OKL_TAX_SOURCES;BILL_TO_PARTY_ID