APPS.EAM_METERASSOC_PUB dependencies on DUAL

Line 149: from dual

145: begin
146: if nvl(p_primary_failure_flag, 'N') = 'Y' then
147:
148: select 'Y' into l_exists_primary_flag
149: from dual
150: where exists
151: (select * from csi_ctr_item_associations
152: where inventory_item_id = p_asset_group_id
153: and (end_date_active is null or end_date_active > sysdate)

Line 243: from dual

239: begin
240: if nvl(p_primary_failure_flag, 'N') = 'Y' then
241:
242: select 'Y' into l_exists_primary_flag
243: from dual
244: where exists
245: (select * from csi_counter_associations
246: where source_object_id = l_maintenance_object_id
247: and (end_date_active is null or end_date_active > sysdate)

Line 578: from dual

574:
575:
576:
577: select 'Y' into l_exists_primary_flag
578: from dual
579: where exists
580: (select * from csi_ctr_item_associations
581: where inventory_item_id = l_asset_group_id
582: and (end_date_active is null or end_date_active > sysdate)

Line 661: from dual

657:
658:
659:
660: select 'Y' into l_exists_primary_flag
661: from dual
662: where exists
663: (select * from csi_counter_associations
664: where source_object_id = l_maint_object_id
665: and (end_date_active is null or end_date_active > sysdate)