DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 1373: --dkagrawa changed the cursor to use new view okl_prod_qlty_val_uv for product quality value instead of product_parameter_v

1369: l_msg_index_out NUMBER;
1370: lx_return_status VARCHAR(1);
1371: l_khr_id NUMBER DEFAULT NULL;
1372: l_contract_number okc_k_headers_b.contract_number%type;
1373: --dkagrawa changed the cursor to use new view okl_prod_qlty_val_uv for product quality value instead of product_parameter_v
1374: CURSOR check_contract_csr(cp_contract_number IN VARCHAR2) IS
1375: SELECT khr.id khr_id
1376: ,khr.contract_number
1377: ,khr.authoring_org_id

Line 1379: okl_prod_qlty_val_uv ppm,

1375: SELECT khr.id khr_id
1376: ,khr.contract_number
1377: ,khr.authoring_org_id
1378: FROM okl_k_headers_full_v khr,
1379: okl_prod_qlty_val_uv ppm,
1380: okc_statuses_b ste
1381: WHERE khr.contract_number = NVL(cp_contract_number, khr.contract_number)
1382: AND khr.pdt_id = ppm.pdt_id
1383: AND ppm.quality_name = 'REVENUE_RECOGNITION_METHOD'