APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 2565: FROM OKC_K_HEADERS_ALL_B CHRB,

2561: AND sts_code IN ('ACTIVE','PASSED')
2562: AND khr_id = p_vp_id
2563: AND NVL(template_yn,'N') = 'Y'; */
2564: SELECT CHRB.ID ID
2565: FROM OKC_K_HEADERS_ALL_B CHRB,
2566: OKL_K_HEADERS KHR
2567: WHERE CHRB.SCS_CODE = 'PROGRAM'
2568: AND CHRB.ID = KHR.ID
2569: AND CHRB.STS_CODE IN ('ACTIVE', 'PASSED')

Line 2739: FROM OKC_K_HEADERS_ALL_B CHRB,

2735: AND sts_code IN ('ACTIVE','PASSED')
2736: AND khr_id = p_vp_id
2737: AND NVL(template_yn,'N') = 'Y'; */
2738: SELECT CHRB.ID ID
2739: FROM OKC_K_HEADERS_ALL_B CHRB,
2740: OKL_K_HEADERS KHR
2741: WHERE CHRB.SCS_CODE = 'PROGRAM'
2742: AND CHRB.ID = KHR.ID
2743: AND CHRB.STS_CODE IN ('ACTIVE', 'PASSED')

Line 4800: from okc_k_headers_all_b

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
4801: where orig_system_source_code = 'OKL_QUOTE'
4802: and orig_system_id1 = lsq.id
4803: and sts_code <> 'ABANDONED');
4804: --end changed by abhsaxen for Bug#6174484

Line 4821: from okc_k_headers_all_b

4817: and lapt.language = userenv('LANG')
4818: and lap.application_status = 'CR-APPROVED'
4819: and lap.reference_number = p_leaseapp_number
4820: and not exists (select 1
4821: from okc_k_headers_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