APPS.MTH_EVENT_PKG dependencies on MTH_EQUIPMENTS_D

Line 273: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b

269: BEGIN
270:
271: SELECT b.equipment_name, a.event_type, a.event_description, To_Char(a.creation_date,'yyyy.mm.dd hh24:mi:ss')
272: INTO l_equip_name, l_event_type, l_event_description, l_event_time
273: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b
274: WHERE a.event_id = p_event_id
275: AND a.equipment_fk_key = b.equipment_pk_key;
276:
277: IF p_event_action_rec.person_fk_key IS NOT NULL

Line 430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e

426: l_system_pk VARCHAR2(30);
427: CURSOR cur_wr
428: IS
429: SELECT b.serial_number, d.ebs_organization_id, c.ASSET_NUMBER, c.ASSET_GROUP_ID
430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e
431:
432: WHERE a.event_id = p_event_id
433: AND a.equipment_fk_key = b.equipment_pk_key
434: AND d.ORGANIZATION_CODE = c.maintenance_org_code