DBA Data[Home] [Help]

APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_TRANSACTION_REASONS

Line 166: FROM MTL_TRANSACTION_REASONS

162:
163: --Query for validating reason name and selecting reason id.
164: CURSOR Reason_Cur(p_reason_Name varchar2) IS
165: SELECT REASON_ID
166: FROM MTL_TRANSACTION_REASONS
167: WHERE REASON_NAME = p_reason_Name
168: AND (DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE);
169:
170: -- Query for validating Transaction_Type_NAme and selecting Transaction_Type_Id

Line 2068: FROM MTL_TRANSACTION_REASONS

2064:
2065: -- Reason query
2066: CURSOR AHL_REASON_CUR (p_reason NUMBER) IS
2067: SELECT 1
2068: FROM MTL_TRANSACTION_REASONS
2069: WHERE REASON_ID = p_reason;
2070:
2071: -- Condition Validaiton
2072: CURSOR Condition_Cur(p_condition NUMBER) IS