DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on MTL_TRANSACTION_REASONS

Line 6536: FROM mtl_transaction_reasons

6532: IS
6533: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6534: IS
6535: SELECT 1
6536: FROM mtl_transaction_reasons
6537: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
6538: AND reason_id = v_reason_id;
6539:
6540: CURSOR cur_val_reason_name (v_reason_name VARCHAR)

Line 6543: FROM mtl_transaction_reasons

6539:
6540: CURSOR cur_val_reason_name (v_reason_name VARCHAR)
6541: IS
6542: SELECT reason_id
6543: FROM mtl_transaction_reasons
6544: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
6545: AND reason_name = v_reason_name;
6546:
6547: i NUMBER;