DBA Data[Home] [Help]

APPS.CS_SERVICE_PVT dependencies on CS_CUSTOMER_PRODUCTS

Line 101: FROM Cs_Customer_Products

97: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;
98: l_cs_contract_line_tem1 cs_contract_line_tem1_csr%ROWTYPE;
99: CURSOR ccpall_pk_csr (p_customer_product_id IN NUMBER) IS
100: SELECT *
101: FROM Cs_Customer_Products
102: WHERE cs_customer_products.customer_product_id = p_customer_product_id;
103: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *

Line 102: WHERE cs_customer_products.customer_product_id = p_customer_product_id;

98: l_cs_contract_line_tem1 cs_contract_line_tem1_csr%ROWTYPE;
99: CURSOR ccpall_pk_csr (p_customer_product_id IN NUMBER) IS
100: SELECT *
101: FROM Cs_Customer_Products
102: WHERE cs_customer_products.customer_product_id = p_customer_product_id;
103: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *
106: FROM Cs_Contracts_All