APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on CSI_CTR_ITEM_ASSOCIATIONS

Line 2066: FROM csi_ctr_item_associations

2062: l_return_message VARCHAR2(100);
2063:
2064: CURSOR c1(p_counter_group_id NUMBER, p_inventory_item_id NUMBER) IS
2065: SELECT counter_id
2066: FROM csi_ctr_item_associations
2067: WHERE nvl(associated_to_group,'N') = 'Y'
2068: AND counter_id IS NOT NULL
2069: AND group_id = p_counter_group_id
2070: AND inventory_item_id = p_inventory_item_id; --Modified for 6112648

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

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

Line 5001: FROM csi_ctr_item_associations

4997: /*
4998: BEGIN
4999: SELECT counter_id
5000: INTO l_counter_id
5001: FROM csi_ctr_item_associations
5002: WHERE inventory_item_id = p_source_object_id_template;
5003: EXCEPTION
5004: WHEN NO_DATA_FOUND THEN
5005: -- This item does not have any counters. Raise a warning message that