APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on MFG_LOOKUPS

Line 786: FROM mfg_lookups

782:
783: --p_operable_flag validation
784:
785: SELECT count(*) INTO l_count
786: FROM mfg_lookups
787: WHERE lookup_type='SYS_YES_NO' AND
788: enabled_flag='Y' AND
789: p_txn_date BETWEEN NVL(start_date_active, p_txn_date) AND
790: NVL(end_date_active,sysdate) AND