1017: and csi.status_flag = 'C'
1018: and cccv.customer_product_id(+) = aueb.csi_item_instance_id
1019: order by aueb.unit_effectivity_id;
1020:
1021: l_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
1022: l_unit_threshold_tbl ahl_ump_unitmaint_pvt.Unit_Threshold_tbl_type;
1023: l_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
1024: l_count Number := 0;
1025: l_index Number := 0;
1018: and cccv.customer_product_id(+) = aueb.csi_item_instance_id
1019: order by aueb.unit_effectivity_id;
1020:
1021: l_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
1022: l_unit_threshold_tbl ahl_ump_unitmaint_pvt.Unit_Threshold_tbl_type;
1023: l_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
1024: l_count Number := 0;
1025: l_index Number := 0;
1026: l_prev_effectivity_id Number := -1;
1019: order by aueb.unit_effectivity_id;
1020:
1021: l_unit_effectivity_tbl ahl_ump_unitmaint_pvt.unit_effectivity_tbl_type;
1022: l_unit_threshold_tbl ahl_ump_unitmaint_pvt.Unit_Threshold_tbl_type;
1023: l_unit_accomplish_tbl ahl_ump_unitmaint_pvt.unit_accomplish_tbl_type;
1024: l_count Number := 0;
1025: l_index Number := 0;
1026: l_prev_effectivity_id Number := -1;
1027: