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