APPS.MTH_EVENT_PKG dependencies on MTH_PERSONNEL_D

Line 124: FROM MTH_EVENT_ACTION_SETUP A, MTH_EVENT_SETUP C, MTH_PERSONNEL_D D

120: (SELECT B.DESCRIPTION FROM FND_LOOKUPS B
121: WHERE B.LOOKUP_CODE = A.ACTION_HANDLER_CODE
122: AND B.LOOKUP_TYPE IN ('MTH_CUSTOM_PLSQL_API','MTH_CUSTOM_WS_API') ))
123: END AS ACTION_HANLDER_API, A.DOMAIN_NAME
124: FROM MTH_EVENT_ACTION_SETUP A, MTH_EVENT_SETUP C, MTH_PERSONNEL_D D
125: WHERE A.EVENT_SETUP_ID = C.EVENT_SETUP_ID
126: AND C.EVENT_TYPE_CODE = p_event_type
127: AND C.EQUIPMENT_FK_KEY = p_equipment_fk_key
128: AND A.PERSONNEL_FK_KEY = D.PERSONNEL_PK_KEY (+)

Line 284: FROM MTH_PERSONNEL_D

280: p_event_action_rec.email_notification = '1'
281: THEN
282: SELECT email_address
283: INTO l_email_id
284: FROM MTH_PERSONNEL_D
285: WHERE personnel_pk_key = p_event_action_rec.person_fk_key;
286:
287: l_subject := 'Alert! Equipment :'|| l_equip_name ||' , ' || 'Event Type : ' || l_event_type ;
288: l_content := 'Event condition :' || l_event_description || ' and Time of event : ' || l_event_time ;

Line 311: FROM MTH_PERSONNEL_D

307: p_event_action_rec.mobile_notification = '1'
308: THEN
309: SELECT mobile_phone_number
310: INTO l_mobile_id
311: FROM MTH_PERSONNEL_D
312: WHERE personnel_pk_key = p_event_action_rec.person_fk_key;
313:
314: IF l_mobile_id IS NULL OR Length(l_mobile_id) = 0
315: THEN