DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_TRANSACTION_REASONS

Line 155: FROM MTL_TRANSACTION_REASONS

151:
152: --Query for validating reason name and selecting reason id.
153: CURSOR Reason_Cur(p_reason_Name varchar2) IS
154: SELECT REASON_ID
155: FROM MTL_TRANSACTION_REASONS
156: WHERE REASON_NAME = p_reason_Name
157: AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);
158:
159: -- Query for validating Transaction_Type_NAme and selecting Transaction_Type_Id

Line 1779: FROM MTL_TRANSACTION_REASONS

1775:
1776: -- Reason query
1777: CURSOR AHL_REASON_CUR (p_reason NUMBER) IS
1778: SELECT 1
1779: FROM MTL_TRANSACTION_REASONS
1780: WHERE REASON_ID = p_reason;
1781:
1782: -- Condition Validaiton
1783: CURSOR Condition_Cur(p_condition NUMBER) IS