APPS.CS_CONTRACTS_PUB dependencies on CS_COVERED_PRODUCTS

Line 227: p_cov_lvl_id IN CS_COVERED_PRODUCTS.COVERAGE_LEVEL_ID%TYPE) IS

223: p_cov_lvl_rec IN contract_cov_lvls_rec_type
224: ) RETURN BOOLEAN IS
225: l_retval BOOLEAN := FALSE;
226: CURSOR chk_csr (
227: p_cov_lvl_id IN CS_COVERED_PRODUCTS.COVERAGE_LEVEL_ID%TYPE) IS
228: SELECT *
229: FROM cs_covered_products
230: WHERE coverage_level_id = p_cov_lvl_id;
231:

Line 229: FROM cs_covered_products

225: l_retval BOOLEAN := FALSE;
226: CURSOR chk_csr (
227: p_cov_lvl_id IN CS_COVERED_PRODUCTS.COVERAGE_LEVEL_ID%TYPE) IS
228: SELECT *
229: FROM cs_covered_products
230: WHERE coverage_level_id = p_cov_lvl_id;
231:
232: l_rec chk_csr%ROWTYPE;
233: BEGIN

Line 470: FROM cs_covered_products ccp

466: SELECT *
467: FROM cs_contract_cov_levels cccl
468: WHERE cp_service_id = p_cp_service_id
469: AND NOT EXISTS (SELECT 'x'
470: FROM cs_covered_products ccp
471: WHERE ccp.coverage_level_id = cccl.coverage_level_id);
472: BEGIN
473: FOR l_rec IN chk_csr(p_services_rec.cp_service_id) LOOP
474: ------------------------------------------------------------------------------