APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on MFG_LOOKUPS

Line 114: FROM mfg_lookups

110: WHERE wip_entity_id = p_wip_entity_id;
111:
112: CURSOR get_yes_no(p_lookup_code NUMBER) IS
113: SELECT meaning
114: FROM mfg_lookups
115: WHERE lookup_type = 'EAM_YES_NO'
116: AND lookup_code = p_lookup_code
117: AND enabled_flag = 'Y'
118: AND (start_date_active is NULL OR sysdate >= start_date_active)

Line 144: l_yes_no mfg_lookups.meaning%TYPE;

140: l_api_name VARCHAR2(100);
141: l_unexpected_excep EXCEPTION;
142: l_wip_entity_name wip_entities.wip_entity_name%TYPE;
143: l_asset_number csi_item_instances.instance_number%TYPE;
144: l_yes_no mfg_lookups.meaning%TYPE;
145: BEGIN
146: l_asset_sub_only := FALSE;
147: l_api_name :='Check_Shortage';
148: