APPS.EAM_PM_LAST_SERVICE_PUB dependencies on CSI_COUNTER_ASSOCIATIONS

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' ;