DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 2127: FROM mtl_transaction_reasons

2123:
2124: CURSOR cur_validate_reason_id (v_reason_id NUMBER)
2125: IS
2126: SELECT reason_id
2127: FROM mtl_transaction_reasons
2128: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2129: AND reason_id = v_reason_id;
2130:
2131: CURSOR cur_get_reason_id (v_reason_name VARCHAR2)

Line 2134: FROM mtl_transaction_reasons

2130:
2131: CURSOR cur_get_reason_id (v_reason_name VARCHAR2)
2132: IS
2133: SELECT reason_id
2134: FROM mtl_transaction_reasons
2135: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2136: AND reason_name = v_reason_name;
2137:
2138: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_txn_param';