[Home] [Help]
1160: cc.counter_id
1161: from
1162: csi_counters_vl cc,
1163: csi_counter_associations cca,
1164: ahl_unit_effectivities_b ue
1165: where
1166: cc.counter_id (+) = cca.counter_id
1167: and cca.source_object_code = 'CP'
1168: and cca.source_object_id = ue.csi_item_instance_id
1228: cc.counter_id
1229: from
1230: csi_counters_vl cc,
1231: csi_counter_associations cca,
1232: ahl_unit_effectivities_b ue
1233: where
1234: cc.counter_id (+) = cca.counter_id
1235: and cca.source_object_code = 'CP'
1236: and cca.source_object_id = ue.csi_item_instance_id
1357:
1358: -- For bug# 4172783.
1359: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1360: SELECT CSI.instance_number, UE.due_date, MR.title
1361: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1362: csi_item_instances CSI
1363: WHERE UE.unit_effectivity_id = p_ue_id
1364: AND UE.mr_header_id = MR.mr_header_id
1365: AND UE.csi_item_instance_id = CSI.instance_id;
1400: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1401: l_err_due_date DATE;
1402: l_err_title ahl_mr_headers_b.title%TYPE;
1403: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1404: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1405: -- added to validate visit status.
1406: l_visit_status VARCHAR2(100);
1407:
1408: BEGIN
3959: -- For processsing object type = 'SR'
3960: /*CURSOR ahl_sr_ue_csr(p_mr_header_id IN NUMBER) IS
3961: SELECT UE1.unit_effectivity_id
3962: FROM ahl_unit_effectivities_app_v UE,
3963: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1
3964: WHERE UER.ue_id = UE.unit_effectivity_id
3965: AND UER.related_ue_id = UE1.unit_effectivity_id
3966: AND UE.object_type = 'SR'
3967: AND (UE.status_code is null or UE.status_code = 'INIT-DUE')