DBA Data[Home] [Help]

APPS.QOT_DEFAULT_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 463: FROM OE_TRANSACTION_TYPES_ALL

459: l_ret_value NUMBER;
460:
461: CURSOR C_Get_PL (l_order_type NUMBER) IS
462: SELECT Price_List_Id
463: FROM OE_TRANSACTION_TYPES_ALL
464: WHERE Transaction_Type_Id = l_order_type
465: AND sysdate BETWEEN nvl(Start_Date_Active,sysdate) AND nvl(End_Date_Active,sysdate);
466:
467: