APPS.EAM_PM_LAST_SERVICE_PUB dependencies on CSI_COUNTERS_B

Line 51: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_meter_id

47:
48: CURSOR c_val_meter_id(p_meter_id number)
49: IS
50: select 'X' from dual where exists
51: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_meter_id
52: union
53: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_meter_id) ;
54: --commnetd for perf issues
55: /* SELECT 'X'

Line 66: CSI_COUNTERS_B em where meaa.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' ;
70: --commnetd for perf issues