DBA Data[Home] [Help]

APPS.CS_BILLRATE_PVT dependencies on CS_COV_BILLING_TYPES

Line 87: FROM Cs_Cov_Billing_Types

83: RETURN VARCHAR2 IS
84: item_not_found_error EXCEPTION;
85: CURSOR cs_coverage_billing_1_csr (p_coverage_billing_type_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Cov_Billing_Types
88: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;
89: l_cs_coverage_billing_types_pk cs_coverage_billing_1_csr%ROWTYPE;
90: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;

Line 88: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;

84: item_not_found_error EXCEPTION;
85: CURSOR cs_coverage_billing_1_csr (p_coverage_billing_type_id IN NUMBER) IS
86: SELECT *
87: FROM Cs_Cov_Billing_Types
88: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;
89: l_cs_coverage_billing_types_pk cs_coverage_billing_1_csr%ROWTYPE;
90: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;
92: BEGIN