DBA Data[Home] [Help]

APPS.CS_COVEREDPRD_PVT dependencies on CS_CONTRACT_COV_LEVELS

Line 92: FROM Cs_Contract_Cov_Levels

88: RETURN VARCHAR2 IS
89: item_not_found_error EXCEPTION;
90: CURSOR cs_contract_coverage1_csr (p_coverage_level_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Cov_Levels
93: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;
94: l_cs_contract_coverage1 cs_contract_coverage1_csr%ROWTYPE;
95: CURSOR ccpall_pk_csr (p_customer_product_id IN NUMBER) IS
96: SELECT *

Line 93: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;

89: item_not_found_error EXCEPTION;
90: CURSOR cs_contract_coverage1_csr (p_coverage_level_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Cov_Levels
93: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;
94: l_cs_contract_coverage1 cs_contract_coverage1_csr%ROWTYPE;
95: CURSOR ccpall_pk_csr (p_customer_product_id IN NUMBER) IS
96: SELECT *
97: FROM Cs_Customer_Products_All