APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_LEASE_APPS_ALL_B

Line 4796: from okl_lease_apps_all_b

4792: and lsqt.language = userenv('LANG')
4793: and lsq.status = 'ACCEPTED'
4794: and lsq.reference_number = p_quote_number
4795: and not exists (select 1
4796: from okl_lease_apps_all_b
4797: where lease_opportunity_id = lop.id
4798: and application_status <> 'WITHDRAWN')
4799: and not exists (select 1
4800: from okc_k_headers_all_b

Line 4826: from okl_lease_apps_all_b

4822: where orig_system_source_code = 'OKL_LEASE_APP'
4823: and orig_system_id1 = lap.id
4824: and sts_code <> 'ABANDONED')
4825: and not exists (select 1
4826: from okl_lease_apps_all_b
4827: where parent_leaseapp_id = lap.id
4828: and application_status not in ('WITHDRAWN' , 'CR-REJECTED'))
4829: ;
4830: --end changed by abhsaxen for Bug#6174484