APPS.EAM_METERS_UTIL dependencies on EAM_PM_SCHEDULING_RULES

Line 844: update eam_pm_scheduling_rules

840: end if;
841: close C;
842:
843: x_temp := p_last_reading + p_change_val + p_current_reading;
844: update eam_pm_scheduling_rules
845: set last_service_reading = x_temp - last_service_reading - runtime_interval
846: where meter_id = p_meter_id
847: and rule_type = 2;
848: end reset_meter;

Line 928: from eam_pm_scheduling_rules pr,

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

Line 988: from eam_pm_scheduling_rules pr,

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

Line 1493: FROM EAM_PM_SCHEDULING_RULES

1489: BEGIN
1490:
1491: SELECT 'Y'
1492: INTO l_exists
1493: FROM EAM_PM_SCHEDULING_RULES
1494: WHERE meter_id = p_meter_id
1495: AND rownum<=1;
1496:
1497: EXCEPTION