APPS.EAM_PM_LAST_SERVICE_PUB dependencies on MTL_EAM_ASSET_ACTIVITIES

Line 61: from mtl_eam_asset_activities where activity_association_id = p_activity_association_id;

57:
58: CURSOR c_val_act_assoc_id(P_ACTIVITY_ASSOCIATION_ID number)
59: IS
60: SELECT 'X'
61: from mtl_eam_asset_activities where activity_association_id = p_activity_association_id;
62:
63: CURSOR c_meter_act_assoc(P_ACTIVITY_ASSOCIATION_ID number, p_meter_id number)
64: IS
65: SELECT 'X' from mtl_eam_asset_activities meaa, CSI_COUNTER_ASSOCIATIONS eam,

Line 65: SELECT 'X' from mtl_eam_asset_activities meaa, CSI_COUNTER_ASSOCIATIONS eam,

61: from mtl_eam_asset_activities where activity_association_id = p_activity_association_id;
62:
63: CURSOR c_meter_act_assoc(P_ACTIVITY_ASSOCIATION_ID number, p_meter_id number)
64: IS
65: SELECT 'X' from mtl_eam_asset_activities meaa, CSI_COUNTER_ASSOCIATIONS eam,
66: CSI_COUNTERS_B em where meaa.activity_association_id
67: = p_activity_association_id
68: and meaa.maintenance_object_id = eam.SOURCE_OBJECT_ID and eam.COUNTER_id =
69: em.COUNTER_id and eam.COUNTER_id = p_meter_id and em.used_in_scheduling = 'Y' ;

Line 72: from mtl_eam_asset_activities meaa, eam_asset_meters_v eam, eam_counters_v em

68: and meaa.maintenance_object_id = eam.SOURCE_OBJECT_ID and eam.COUNTER_id =
69: em.COUNTER_id and eam.COUNTER_id = p_meter_id and em.used_in_scheduling = 'Y' ;
70: --commnetd for perf issues
71: /* SELECT 'X'
72: from mtl_eam_asset_activities meaa, eam_asset_meters_v eam, eam_counters_v em
73: where meaa.activity_association_id = p_activity_association_id
74: and meaa.maintenance_object_id = eam.maintenance_object_id
75: and eam.meter_id = em.meter_id
76: and eam.meter_id = p_meter_id