APPS.OKL_DEAL_CREATE_PUB dependencies on OKL_LEASE_APPS_ALL_B

Line 4793: from okl_lease_apps_all_b

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

Line 4823: from okl_lease_apps_all_b

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