APPS.EAM_METERS_UTIL dependencies on CSI_COUNTERS_B

Line 147: from csi_counters_b

143: l_use_past_reading number;
144: begin
145: select default_usage_rate,use_past_reading
146: into l_user_defined_rate, l_use_past_reading
147: from csi_counters_b
148: where counter_id = p_meter_id;
149:
150: return get_meter_usage_rate(p_meter_id,l_user_defined_rate,l_use_past_reading);
151:

Line 212: from csi_counters_b

208:
209: begin
210: select eam_required_flag
211: into l_required_flag
212: from csi_counters_b
213: where counter_id = p_meter_id;
214:
215: if nvl(l_required_flag, 'N') = 'Y' then
216: l_required_flag_b := true;

Line 269: from csi_counters_b

265: return boolean IS
266:
267: cursor C is
268: select used_in_scheduling
269: from csi_counters_b
270: where counter_id = p_meter_id
271: and SYSDATE BETWEEN nvl(start_date_active, SYSDATE-1) AND nvl(end_date_active, SYSDATE+1);
272:
273: x_used_in_scheduling varchar2(1);

Line 827: from csi_counters_b

823: p_last_reading in number,
824: p_change_val in number) is
825: cursor C is
826: select 'X'
827: from csi_counters_b
828: where counter_id = p_meter_id
829: and SYSDATE BETWEEN nvl(start_date_active, SYSDATE-1) AND nvl(end_date_active, SYSDATE+1);
830:
831: x_temp number;

Line 930: csi_counters_b ccb

926: cursor testmr is
927: select 'X'
928: from eam_pm_scheduling_rules pr,
929: eam_pm_activities epa,
930: csi_counters_b ccb
931: where pr.meter_id = ccb.counter_id
932: and epa.activity_association_id = p_activity_assoc_id
933: and pr.pm_schedule_id = epa.pm_schedule_id
934: and pr.rule_type = 2

Line 989: csi_counters_b ccb

985: x_num number;
986: begin
987: select count(*) into x_num
988: from eam_pm_scheduling_rules pr,
989: csi_counters_b ccb
990: where pr.meter_id = ccb.counter_id
991: and pr.pm_schedule_id = p_parent_pm_id
992: and pr.rule_type = 2
993: and SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1) AND nvl(ccb.end_date_active, SYSDATE+1);

Line 1297: from csi_counters_b

1293: if (l_prev_reading is not null or
1294: (l_next_reading is not null and
1295: (l_next_reset is null or l_next_reset='N'))) then
1296: select direction into l_meter_type
1297: from csi_counters_b
1298: where counter_id = p_meter_id;
1299: else
1300: return false;
1301: end if;

Line 1340: from csi_counters_b

1336: return;
1337: end if;
1338:
1339: select reading_type into l_meter_type
1340: from csi_counters_b
1341: where counter_id = p_meter_id;
1342:
1343: if(l_meter_type <> 2) then
1344: return;