APPS.OKL_DEAL_CREATE_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 2562: FROM OKC_K_HEADERS_ALL_B CHRB,

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

Line 2736: FROM OKC_K_HEADERS_ALL_B CHRB,

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

Line 4797: from okc_k_headers_all_b

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

Line 4818: from okc_k_headers_all_b

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