APPS.EAM_METERS_UTIL dependencies on EAM_PM_SCHEDULING_RULES

Line 848: update eam_pm_scheduling_rules

844: end if;
845: close C;
846:
847: x_temp := p_last_reading + p_change_val + p_current_reading;
848: update eam_pm_scheduling_rules
849: set last_service_reading = x_temp - last_service_reading - runtime_interval
850: where meter_id = p_meter_id
851: and rule_type = 2;
852: end reset_meter;

Line 932: from eam_pm_scheduling_rules pr,

928: and nvl(eps.to_effective_date, sysdate+1) > sysdate;
929:
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

Line 992: from eam_pm_scheduling_rules pr,

988: x_child_pm number;
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

Line 1497: FROM EAM_PM_SCHEDULING_RULES

1493: BEGIN
1494:
1495: SELECT 'Y'
1496: INTO l_exists
1497: FROM EAM_PM_SCHEDULING_RULES
1498: WHERE meter_id = p_meter_id
1499: AND rownum<=1;
1500:
1501: EXCEPTION