DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on CS_CSI_COUNTER_GROUPS

Line 4793: FROM csi_ctr_item_associations cia, cs_csi_counter_groups cg

4789:
4790: CURSOR ctr_grp_assoc(p_source_object_id_template NUMBER) IS
4791: SELECT cia.counter_id, cia.group_id,
4792: cia.associated_to_group, cia.primary_failure_flag
4793: FROM csi_ctr_item_associations cia, cs_csi_counter_groups cg
4794: WHERE cia.group_id = cg.counter_group_id
4795: AND cia.inventory_item_id = p_source_object_id_template
4796: AND cia.counter_id IS NULL
4797: AND nvl (cia.end_date_active, sysdate+1) > sysdate