DBA Data[Home] [Help]

APPS.GME_RESOURCE_ENGINE_PVT dependencies on MTL_TRANSACTION_REASONS

Line 2007: FROM mtl_transaction_reasons

2003:
2004: CURSOR cur_validate_reason_id (v_reason_id NUMBER)
2005: IS
2006: SELECT reason_id
2007: FROM mtl_transaction_reasons
2008: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2009: AND reason_id = v_reason_id;
2010:
2011: CURSOR cur_get_reason_id (v_reason_name VARCHAR2)

Line 2014: FROM mtl_transaction_reasons

2010:
2011: CURSOR cur_get_reason_id (v_reason_name VARCHAR2)
2012: IS
2013: SELECT reason_id
2014: FROM mtl_transaction_reasons
2015: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
2016: AND reason_name = v_reason_name;
2017:
2018: l_api_name CONSTANT VARCHAR2 (30) := 'validate_rsrc_txn_param';