APPS.EAM_PMDEF_PUB dependencies on CSI_COUNTERS_B

Line 407: from CSI_COUNTER_ASSOCIATIONS cca, CSI_COUNTERS_B ccb

403: if (a_pm_rule.meter_id is not null) then
404:
405: --added for performance issues.
406: select cca.counter_id into l_meter_id
407: from CSI_COUNTER_ASSOCIATIONS cca, CSI_COUNTERS_B ccb
408: where cca.counter_id = ccb.counter_id
409: and ccb.created_from_counter_tmpl_id=a_pm_rule.meter_id
410: and cca.source_object_id= l_maintenance_object_id ;
411:

Line 456: (select initial_reading from CSI_COUNTERS_B where counter_id = a_pm_rule.meter_id

452: if a_pm_rule.meter_id is not null then
453:
454: --added for performance issues
455: select initial_reading into l_initial_reading from
456: (select initial_reading from CSI_COUNTERS_B where counter_id = a_pm_rule.meter_id
457: union
458: select initial_reading from CSI_COUNTER_TEMPLATE_B where counter_id = a_pm_rule.meter_id
459: );
460: select EAM_LAST_CYCLIC_ACT into l_last_act from eam_pm_schedulings

Line 1811: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id

1807:
1808: -- validate that the meter id is valid
1809: --added for perofrmance issues
1810: select 1 into l_count from dual where exists
1811: (select COUNTER_ID from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1812: union
1813: select COUNTER_ID from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id) ;
1814:
1815:

Line 1825: (select direction from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id

1821: -- ascending: effective to > effective from, and vice versa
1822:
1823: --added for perofrmance issues
1824: select direction into l_value_change_dir from
1825: (select direction from CSI_COUNTERS_B where counter_id = p_pm_rule_rec.meter_id
1826: union
1827: select direction from CSI_COUNTER_TEMPLATE_B where counter_id = p_pm_rule_rec.meter_id);
1828:
1829: if ((l_value_change_dir='A' -- ascending