DBA Data[Home] [Help]

APPS.OKS_BTL_PVT dependencies on OKS_BILL_TRANSACTIONS_V

Line 438: from OKS_BILL_TRANSACTIONS_V

434: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
435: l_dummy_var VARCHAR2(1) := '?';
436: Cursor l_btn_Csr Is
437: select 'x'
438: from OKS_BILL_TRANSACTIONS_V
439: where id = P_Btn_id;
440:
441: Begin
442: If p_btn_id = OKC_API.G_MISS_NUM OR

Line 2177: FROM Oks_Bill_Transactions_V

2173: CREATION_DATE,
2174: LAST_UPDATED_BY,
2175: LAST_UPDATE_DATE,
2176: LAST_UPDATE_LOGIN
2177: FROM Oks_Bill_Transactions_V
2178: WHERE oks_bill_transactions_v.id = p_id;
2179: l_okc_btnv_pk okc_btnv_pk_csr%ROWTYPE;
2180: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2181: l_row_notfound BOOLEAN := TRUE;

Line 2178: WHERE oks_bill_transactions_v.id = p_id;

2174: LAST_UPDATED_BY,
2175: LAST_UPDATE_DATE,
2176: LAST_UPDATE_LOGIN
2177: FROM Oks_Bill_Transactions_V
2178: WHERE oks_bill_transactions_v.id = p_id;
2179: l_okc_btnv_pk okc_btnv_pk_csr%ROWTYPE;
2180: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2181: l_row_notfound BOOLEAN := TRUE;
2182: BEGIN