DBA Data[Home] [Help]

APPS.OKS_BPE_PVT dependencies on OKC_TIME_CODE_UNITS_V

Line 1159: FROM Okc_Time_Code_Units_V

1155:
1156: CURSOR okc_tcuv_pk_csr (p_tce_code IN VARCHAR2,
1157: p_uom_code IN VARCHAR2) IS
1158: SELECT 'x'
1159: FROM Okc_Time_Code_Units_V
1160: WHERE okc_time_code_units_v.tce_code = p_tce_code
1161: AND okc_time_code_units_v.uom_code = p_uom_code;
1162: l_okc_tcuv_pk okc_tcuv_pk_csr%ROWTYPE;
1163:

Line 1160: WHERE okc_time_code_units_v.tce_code = p_tce_code

1156: CURSOR okc_tcuv_pk_csr (p_tce_code IN VARCHAR2,
1157: p_uom_code IN VARCHAR2) IS
1158: SELECT 'x'
1159: FROM Okc_Time_Code_Units_V
1160: WHERE okc_time_code_units_v.tce_code = p_tce_code
1161: AND okc_time_code_units_v.uom_code = p_uom_code;
1162: l_okc_tcuv_pk okc_tcuv_pk_csr%ROWTYPE;
1163:
1164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1161: AND okc_time_code_units_v.uom_code = p_uom_code;

1157: p_uom_code IN VARCHAR2) IS
1158: SELECT 'x'
1159: FROM Okc_Time_Code_Units_V
1160: WHERE okc_time_code_units_v.tce_code = p_tce_code
1161: AND okc_time_code_units_v.uom_code = p_uom_code;
1162: l_okc_tcuv_pk okc_tcuv_pk_csr%ROWTYPE;
1163:
1164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1165: l_row_notfound BOOLEAN := TRUE;