APPS.AHL_PRD_WORKORDER_PVT dependencies on FND_LOOKUPS

Line 799: FROM FND_LOOKUPS

795: -- FP bug# 7631453
796: CURSOR get_hold_reason_code_csr(c_hold_reason VARCHAR2)
797: IS
798: SELECT Lookup_code
799: FROM FND_LOOKUPS
800: WHERE lookup_type = 'AHL_PRD_WO_HOLD_REASON'
801: AND MEANING = c_hold_reason
802: AND NVL(start_date_active, SYSDATE - 1) <= SYSDATE
803: AND NVL(end_date_active, SYSDATE + 1) > SYSDATE