APPS.CS_SERVICE_PVT dependencies on CS_CONTRACT_LINE_TPLTS

Line 96: FROM Cs_Contract_Line_Tplts

92: WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;
93: l_cs_contracts_statuses_pk cs_contracts_statuses_pk_csr%ROWTYPE;
94: CURSOR cs_contract_line_tem1_csr (p_contract_line_template_id IN NUMBER) IS
95: SELECT *
96: FROM Cs_Contract_Line_Tplts
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 *

Line 97: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;

93: l_cs_contracts_statuses_pk cs_contracts_statuses_pk_csr%ROWTYPE;
94: CURSOR cs_contract_line_tem1_csr (p_contract_line_template_id IN NUMBER) IS
95: SELECT *
96: FROM Cs_Contract_Line_Tplts
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