APPS.CS_SERVICE_PVT dependencies on CS_CONTRACT_STATUSES

Line 91: FROM Cs_Contract_Statuses

87: RETURN VARCHAR2 IS
88: item_not_found_error EXCEPTION;
89: CURSOR cs_contracts_statuses_pk_csr (p_contract_status_id IN NUMBER) IS
90: SELECT *
91: FROM Cs_Contract_Statuses
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 *

Line 92: WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;

88: item_not_found_error EXCEPTION;
89: CURSOR cs_contracts_statuses_pk_csr (p_contract_status_id IN NUMBER) IS
90: SELECT *
91: FROM Cs_Contract_Statuses
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