DBA Data[Home] [Help]

APPS.EAM_METER_PUB dependencies on CSI_COUNTER_ASSOCIATIONS

Line 581: from csi_counter_associations

577: is
578:
579: CURSOR primary_failure_flag_csr (p_meter_id NUMBER) is
580: select instance_association_id, counter_id, primary_failure_flag
581: from csi_counter_associations
582: where counter_id = p_meter_id;
583:
584: l_api_name CONSTANT VARCHAR2(30) := 'update_meter';
585: l_api_version CONSTANT NUMBER := 1.0;

Line 700: in csi_counter_associations table. A SELECT to check whether the primary_failure_flag is

696:
697: begin
698: /* Bug 6832829
699: When a meter is associated with multiple assets, multiple asociations get created
700: in csi_counter_associations table. A SELECT to check whether the primary_failure_flag is
701: 'Y' thus returns more than one row. Need to change the code to loop through a cursor
702: and check for the first record with primary_failure_flag set to 'Y'.
703: */
704: OPEN primary_failure_flag_csr(p_meter_id);