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 831: from csi_counters_b

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

Line 934: csi_counters_b ccb

930: cursor testmr is
931: select 'X'
932: from eam_pm_scheduling_rules pr,
933: eam_pm_activities epa,
934: csi_counters_b ccb
935: where pr.meter_id = ccb.counter_id
936: and epa.activity_association_id = p_activity_assoc_id
937: and pr.pm_schedule_id = epa.pm_schedule_id
938: and pr.rule_type = 2

Line 993: csi_counters_b ccb

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

Line 1301: from csi_counters_b

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

Line 1344: from csi_counters_b

1340: return;
1341: end if;
1342:
1343: select reading_type into l_meter_type
1344: from csi_counters_b
1345: where counter_id = p_meter_id;
1346:
1347: if(l_meter_type <> 2) then
1348: return;