APPS.CS_CONTRACTS_PUB dependencies on CS_CONTRACT_COV_LEVELS

Line 213: p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS

209: l_return_error_exc EXCEPTION;
210: l_children_exist BOOLEAN := FALSE;
211:
212: CURSOR chk_csr (
213: p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
214: SELECT *
215: FROM cs_contract_cov_levels
216: WHERE cp_service_id = p_cp_service_id;
217:

Line 215: FROM cs_contract_cov_levels

211:
212: CURSOR chk_csr (
213: p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
214: SELECT *
215: FROM cs_contract_cov_levels
216: WHERE cp_service_id = p_cp_service_id;
217:
218: l_cov_lvls_tbl contract_cov_lvls_tbl_type;
219: ------------------------------------------

Line 465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS

461: ) RETURN VARCHAR2 IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
463: l_return_error_exc EXCEPTION;
464: l_overlap_flag VARCHAR2(1) := 'N';
465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
466: SELECT *
467: FROM cs_contract_cov_levels cccl
468: WHERE cp_service_id = p_cp_service_id
469: AND NOT EXISTS (SELECT 'x'

Line 467: FROM cs_contract_cov_levels cccl

463: l_return_error_exc EXCEPTION;
464: l_overlap_flag VARCHAR2(1) := 'N';
465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
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);