DBA Data[Home] [Help]

APPS.CS_COVEREDPRD_PVT dependencies on CS_CUSTOMER_PRODUCTS_ALL

Line 97: FROM Cs_Customer_Products_All

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
98: WHERE cs_customer_products_all.customer_product_id = p_customer_product_id;
99: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;

Line 98: WHERE cs_customer_products_all.customer_product_id = p_customer_product_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
98: WHERE cs_customer_products_all.customer_product_id = p_customer_product_id;
99: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;
102: BEGIN