DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_PROD_QLTY_VAL_UV

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

1520: l_msg_index_out NUMBER;
1521: lx_return_status VARCHAR(1);
1522: l_khr_id NUMBER DEFAULT NULL;
1523: l_contract_number okc_k_headers_b.contract_number%type;
1524: --dkagrawa changed the cursor to use new view okl_prod_qlty_val_uv for product quality value instead of product_parameter_v
1525: CURSOR check_contract_csr(cp_contract_number IN VARCHAR2) IS
1526: SELECT khr.id khr_id
1527: ,khr.contract_number
1528: ,khr.authoring_org_id

Line 1530: okl_prod_qlty_val_uv ppm,

1526: SELECT khr.id khr_id
1527: ,khr.contract_number
1528: ,khr.authoring_org_id
1529: FROM okl_k_headers_full_v khr,
1530: okl_prod_qlty_val_uv ppm,
1531: okc_statuses_b ste
1532: WHERE khr.contract_number = NVL(cp_contract_number, khr.contract_number)
1533: AND khr.pdt_id = ppm.pdt_id
1534: AND ppm.quality_name = 'REVENUE_RECOGNITION_METHOD'