DBA Data[Home] [Help]

APPS.OKL_SALES_QUOTE_QA_PVT dependencies on OKC_K_HEADERS_V

Line 3325: from okc_k_headers_v tbl

3321: AND CAF.dnz_qte_id=p_quote_id;
3322: ---Check the Date Condition
3323: CURSOR c_vp_rec(p_vp_id NUMBER,p_contract_start_date DATE) IS
3324: select 'x'
3325: from okc_k_headers_v tbl
3326: where tbl.id=p_vp_id
3327: AND p_contract_start_date between tbl.start_date and NVL(tbl.end_date,p_contract_start_date)
3328: AND tbl.SCS_CODE='PROGRAM'
3329: AND tbl.STS_CODE='ACTIVE'