APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1007: FROM AHL_UNIT_EFFECTIVITIES_B

1003:
1004: -- SALOGAN added the following for Complex Mx - Begin
1005: CURSOR is_NR_UE(p_ue_id IN NUMBER) IS
1006: SELECT 'Y'
1007: FROM AHL_UNIT_EFFECTIVITIES_B
1008: WHERE UNIT_EFFECTIVITY_ID = p_ue_id
1009: AND CS_INCIDENT_ID IS NOT NULL;
1010: -- SALOGAN added the following for Complex Mx - End
1011:

Line 1343: ahl_unit_effectivities_b ue

1339: cc.counter_id
1340: from
1341: csi_counters_vl cc,
1342: csi_counter_associations cca,
1343: ahl_unit_effectivities_b ue
1344: where
1345: cc.counter_id (+) = cca.counter_id
1346: and cca.source_object_code = 'CP'
1347: and cca.source_object_id = ue.csi_item_instance_id

Line 1411: ahl_unit_effectivities_b ue

1407: cc.counter_id
1408: from
1409: csi_counters_vl cc,
1410: csi_counter_associations cca,
1411: ahl_unit_effectivities_b ue
1412: where
1413: cc.counter_id (+) = cca.counter_id
1414: and cca.source_object_code = 'CP'
1415: and cca.source_object_id = ue.csi_item_instance_id

Line 1528: FROM AHL_UNIT_EFFECTIVITIES_B

1524:
1525: --pdoki added for ER 9583373
1526: CURSOR chk_mr_unplan (p_mr_header_id IN NUMBER, p_instance_id IN NUMBER) IS
1527: SELECT 'x'
1528: FROM AHL_UNIT_EFFECTIVITIES_B
1529: WHERE manually_planned_flag = 'Y'
1530: AND mr_header_id = p_mr_header_id
1531: AND csi_item_instance_id = p_instance_id
1532: AND (status_code IS NULL);

Line 1552: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,

1548:
1549: -- For bug# 4172783.
1550: CURSOR l_ue_err_details_csr (p_ue_id IN NUMBER) IS
1551: SELECT CSI.instance_number, UE.due_date, MR.title
1552: FROM ahl_unit_effectivities_b UE, ahl_mr_headers_b MR,
1553: csi_item_instances CSI
1554: WHERE UE.unit_effectivity_id = p_ue_id
1555: AND UE.mr_header_id = MR.mr_header_id
1556: AND UE.csi_item_instance_id = CSI.instance_id;

Line 1583: FROM AHL_UNIT_EFFECTIVITIES_B

1579:
1580: -- SALOGAN added the following for Complex Mx - Begin
1581: CURSOR is_NR_UE(p_ue_id IN NUMBER) IS
1582: SELECT 'Y'
1583: FROM AHL_UNIT_EFFECTIVITIES_B
1584: WHERE UNIT_EFFECTIVITY_ID = p_ue_id
1585: AND CS_INCIDENT_ID IS NOT NULL;
1586: -- SALOGAN added the following for Complex Mx - End
1587:

Line 1609: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;

1605: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1606: l_err_due_date DATE;
1607: l_err_title ahl_mr_headers_b.title%TYPE;
1608: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1609: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1610: -- added to validate visit status.
1611: l_visit_status VARCHAR2(100);
1612: --pdoki added for ER 9583373
1613: l_manually_plan_flag VARCHAR2(1);

Line 4278: FROM ahl_unit_effectivities_b UE,

4274: -- SATRAJEN :: Changed for USAF Backporting :: Feb 2012
4275: CURSOR ahl_sr_ue_csr(p_mr_header_id IN NUMBER) IS
4276: --SELECT UE1.unit_effectivity_id : bug# 12639381: using uer.related_ue_id instead to avoid changing code reference to 'unit_effectivity_id'
4277: SELECT UER.related_ue_id
4278: FROM ahl_unit_effectivities_b UE,
4279: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1
4280: WHERE UER.ue_id = UE.unit_effectivity_id
4281: AND UER.related_ue_id = UE1.unit_effectivity_id
4282: AND UE.object_type = 'SR'

Line 4279: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1

4275: CURSOR ahl_sr_ue_csr(p_mr_header_id IN NUMBER) IS
4276: --SELECT UE1.unit_effectivity_id : bug# 12639381: using uer.related_ue_id instead to avoid changing code reference to 'unit_effectivity_id'
4277: SELECT UER.related_ue_id
4278: FROM ahl_unit_effectivities_b UE,
4279: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1
4280: WHERE UER.ue_id = UE.unit_effectivity_id
4281: AND UER.related_ue_id = UE1.unit_effectivity_id
4282: AND UE.object_type = 'SR'
4283: AND (UE.status_code is null or UE.status_code = 'INIT-DUE')