DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on MTL_TRANSACTION_REASONS

Line 6126: FROM mtl_transaction_reasons

6122: IS
6123: CURSOR cur_val_reason_id (v_reason_id NUMBER)
6124: IS
6125: SELECT 1
6126: FROM mtl_transaction_reasons
6127: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
6128: AND reason_id = v_reason_id;
6129:
6130: CURSOR cur_val_reason_name (v_reason_name VARCHAR)

Line 6133: FROM mtl_transaction_reasons

6129:
6130: CURSOR cur_val_reason_name (v_reason_name VARCHAR)
6131: IS
6132: SELECT reason_id
6133: FROM mtl_transaction_reasons
6134: WHERE NVL (disable_date, SYSDATE + 1) > SYSDATE
6135: AND reason_name = v_reason_name;
6136:
6137: i NUMBER;