DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_TRANSACTION_REASONS

Line 380: from mtl_transaction_reasons

376: /* Finding out Reason ID from Reason Name */
377: if(p_reason_id IS NULL and p_reason IS NOT NULL) then
378: Begin
379: select reason_id into p_reason_id
380: from mtl_transaction_reasons
381: where
382: reason_name = p_reason
383: and nvl(disable_date,sysdate+1) > sysdate ;
384: exception