[Home] [Help]
APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on CSI_COUNTER_TEMPLATE_B
Line 4783: FROM csi_ctr_item_associations cia, csi_counter_template_b ctr
4779:
4780: CURSOR ctr_item_assoc(p_source_object_id_template NUMBER) IS
4781: SELECT cia.counter_id, cia.group_id, cia.associated_to_group,
4782: ctr.counter_type, cia.primary_failure_flag
4783: FROM csi_ctr_item_associations cia, csi_counter_template_b ctr
4784: WHERE cia.counter_id = ctr.counter_id
4785: AND inventory_item_id = p_source_object_id_template
4786: AND nvl(cia.associated_to_group,'N') = 'N'
4787: AND nvl (cia.end_date_active, sysdate+1) > sysdate