DBA Data[Home] [Help]

APPS.OKL_LEASEAPP_TEMPLATE_PVT dependencies on OKC_K_HEADERS_B

Line 503: FROM okc_k_headers_b chr,

499: SELECT MAX(START_DATE) max_start_date
500: FROM
501: (
502: SELECT chr.START_DATE START_DATE
503: FROM okc_k_headers_b chr,
504: okl_vp_associations vpa,
505: Okl_Leaseapp_Templates lat,
506: okl_leaseapp_templ_versions_b lav
507: WHERE chr.scs_code = 'PROGRAM'

Line 1188: FROM OKC_K_HEADERS_B OKH,

1184:
1185: --Validate Contract Template
1186: CURSOR c_validate_contract_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
1187: SELECT OKH.CONTRACT_NUMBER TEMPLATE_NUMBER
1188: FROM OKC_K_HEADERS_B OKH,
1189: OKL_LEASEAPP_TEMPLATES LATV,
1190: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV,
1191: OKL_K_HEADERS KHR,
1192: OKC_STATUSES_V STS

Line 1398: FROM okc_k_headers_b chr,

1394: SELECT MAX(START_DATE) max_start_date
1395: FROM
1396: (
1397: SELECT chr.START_DATE START_DATE
1398: FROM okc_k_headers_b chr,
1399: okl_vp_associations vpa,
1400: Okl_Leaseapp_Templates lat,
1401: okl_leaseapp_templ_versions_b lav
1402: WHERE chr.scs_code = 'PROGRAM'