APPS.EAM_METERASSOC_PUB dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 151: (select * from csi_ctr_item_associations

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)
154: and nvl(primary_failure_flag, 'N') = 'Y');
155:

Line 564: FROM csi_ctr_item_associations ccia

560: IF p_tmpl_flag = 'Y' THEN
561:
562: SELECT ccia.object_version_number, inventory_item_id
563: INTO l_object_version_number, l_asset_group_id
564: FROM csi_ctr_item_associations ccia
565: WHERE ccia.ctr_association_id = p_association_id;
566:
567: IF (l_plog) THEN
568: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 580: (select * from csi_ctr_item_associations

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)
583: and ctr_association_id <> p_association_id
584: and nvl(primary_failure_flag, 'N') = 'Y');