APPS.AHL_PRD_DF_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 441: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

437:
438: );
439: */
440: SELECT 'x'
441: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
442: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
443: WHERE CA.source_object_id = UE.csi_item_instance_id
444: AND ca.source_object_code = 'CP'
445: AND CP.counter_template_name = MRI.counter_name

Line 452: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

448: AND MRE.mr_header_id = UE.mr_header_id
449: AND UE.unit_effectivity_id = p_unit_effectivity_id
450: UNION
451: SELECT 'x'
452: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
453: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
454: WHERE CA.source_object_id = UE.csi_item_instance_id
455: AND ca.source_object_code = 'CP'
456: AND CP.counter_template_name = MRI.counter_name

Line 5053: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

5049: );
5050: */
5051:
5052: SELECT 'x'
5053: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5054: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5055: WHERE CA.source_object_id = UE.csi_item_instance_id
5056: AND ca.source_object_code = 'CP'
5057: AND CP.counter_template_name = MRI.counter_name

Line 5064: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,

5060: AND MRE.mr_header_id = UE.mr_header_id
5061: AND UE.unit_effectivity_id = p_unit_effectivity_id
5062: UNION
5063: SELECT 'x'
5064: from csi_counter_associations ca, csi_counters_vl CP, AHL_MR_INTERVALS_V MRI,
5065: AHL_MR_EFFECTIVITIES MRE, AHL_UNIT_EFFECTIVITIES_B UE
5066: WHERE CA.source_object_id = UE.csi_item_instance_id
5067: AND ca.source_object_code = 'CP'
5068: AND CP.counter_template_name = MRI.counter_name