DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on CSI_TXN_TYPES

Line 3577: FROM CSI_Txn_Types ctt,

3573: P_App_Short_Name IN VARCHAR2) RETURN NUMBER IS
3574: l_Txn_Type_Id NUMBER;
3575: CURSOR Txn_Type_Cur IS
3576: SELECT ctt.Transaction_Type_Id Transaction_Type_Id
3577: FROM CSI_Txn_Types ctt,
3578: FND_Application fa
3579: WHERE ctt.Source_Transaction_Type = P_Txn_Type
3580: AND fa.application_id = ctt.Source_Application_ID
3581: AND fa.Application_Short_Name = P_App_Short_Name;

Line 3593: FROM CSI_Txn_Types

3589: FUNCTION Get_Txn_Type_Code(P_Txn_Id IN NUMBER) RETURN VARCHAR2 IS
3590: l_Txn_Type_Code VARCHAR2(100);
3591: CURSOR Txn_Type_Id_Cur IS
3592: SELECT Source_Transaction_Type
3593: FROM CSI_Txn_Types
3594: WHERE Transaction_Type_Id = P_Txn_Id;
3595: BEGIN
3596: OPEN Txn_Type_Id_Cur;
3597: FETCH Txn_Type_Id_Cur INTO l_Txn_Type_Code;