APPS.EAM_PMDEF_PUB dependencies on CSI_COUNTERS_B

Line 410: from CSI_COUNTER_ASSOCIATIONS cca, CSI_COUNTERS_B ccb

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

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

455: if a_pm_rule.meter_id is not null then
456:
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

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

1894:
1895: -- validate that the meter id is valid
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:

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

1908: -- ascending: effective to > effective from, and vice versa
1909:
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