APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on MFG_LOOKUPS

Line 110: FROM mfg_lookups

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

Line 140: l_yes_no mfg_lookups.meaning%TYPE;

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