DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_TRANSACTION_REASONS

Line 282: from mtl_transaction_reasons

278: /* Finding out Reason ID from Reason Name */
279: if(p_reason_id IS NULL and p_reason IS NOT NULL) then
280: Begin
281: select reason_id into p_reason_id
282: from mtl_transaction_reasons
283: where
284: reason_name = p_reason
285: and nvl(disable_date,sysdate+1) > sysdate ;
286: exception