APPS.AHL_UC_UTILIZATION_PVT dependencies on CSI_COUNTERS_B

Line 783: FROM CSI_COUNTERS_B C

779: SELECT NVL((select ccr.net_reading
780: from csi_counter_readings ccr
781: where ccr.counter_value_id = c.ctr_val_max_seq_no), 0) counter_reading,
782: DEFAULTED_GROUP_ID counter_group_id
783: FROM CSI_COUNTERS_B C
784: WHERE counter_id = c_counter_id
785: -- Changes by jaramana on 28-DEC-2009 for bug 9229943
786: -- Lock the CSI_COUNTERS_B row to prevent incorrect updates
787: FOR UPDATE OF c.ctr_val_max_seq_no;

Line 786: -- Lock the CSI_COUNTERS_B row to prevent incorrect updates

782: DEFAULTED_GROUP_ID counter_group_id
783: FROM CSI_COUNTERS_B C
784: WHERE counter_id = c_counter_id
785: -- Changes by jaramana on 28-DEC-2009 for bug 9229943
786: -- Lock the CSI_COUNTERS_B row to prevent incorrect updates
787: FOR UPDATE OF c.ctr_val_max_seq_no;
788:
789: -- Begin changes by jaramana on Feb 20, 2008 for Bug 6782765
790: CURSOR is_counter_change_type_csr(c_counter_id NUMBER) IS

Line 791: select 'Y' from CSI_COUNTERS_B

787: FOR UPDATE OF c.ctr_val_max_seq_no;
788:
789: -- Begin changes by jaramana on Feb 20, 2008 for Bug 6782765
790: CURSOR is_counter_change_type_csr(c_counter_id NUMBER) IS
791: select 'Y' from CSI_COUNTERS_B
792: where counter_id = c_counter_id
793: and reading_type = 2;
794:
795: l_change_type_flag VARCHAR2(1) := 'N';

Line 976: select 'Y' from CSI_COUNTERS_B

972: l_get_current_value_name get_current_value_name%ROWTYPE;
973:
974: -- Begin changes by jaramana on Feb 20, 2008 for Bug 6782765
975: CURSOR is_counter_change_type_csr(c_counter_id NUMBER) IS
976: select 'Y' from CSI_COUNTERS_B
977: where counter_id = c_counter_id
978: and reading_type = 2;
979:
980: l_change_type_flag VARCHAR2(1) := 'N';