APPS.EAM_PMDEF_PUB dependencies on CSI_COUNTER_TEMPLATE_B

Line 461: select initial_reading from CSI_COUNTER_TEMPLATE_B where counter_id = a_pm_rule.meter_id

457: --added for performance issues
458: select initial_reading into l_initial_reading from
459: (select initial_reading from CSI_COUNTERS_B where counter_id = a_pm_rule.meter_id
460: union
461: select initial_reading from CSI_COUNTER_TEMPLATE_B where counter_id = a_pm_rule.meter_id
462: );
463: select EAM_LAST_CYCLIC_ACT into l_last_act from eam_pm_schedulings
464: where pm_schedule_id = l_pm_schedule_id;
465:

Line 1900: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id) ;

1896: --added for perofrmance issues
1897: select 1 into l_count from dual where exists
1898: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1899: union
1900: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id) ;
1901:
1902:
1903: if (l_count=0) then
1904: x_reason_failed:='EAM_PM_RUN_INVALID_METER_ID';

Line 1914: select direction from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id);

1910: --added for perofrmance issues
1911: select direction into l_value_change_dir from
1912: (select direction from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1913: union
1914: select direction from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id);
1915:
1916: if ((l_value_change_dir='A' -- ascending
1917: and p_pm_rule_rec.effective_reading_from > p_pm_rule_rec.effective_reading_to)
1918: or