APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 822: FROM AHL_UE_RELATIONSHIPS

818:
819:
820: CURSOR l_child_mr_csr(p_ue_id IN NUMBER) IS
821: SELECT 'x'
822: FROM AHL_UE_RELATIONSHIPS
823: WHERE related_ue_id = p_ue_id;
824:
825: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
826: p_item_instance_id IN NUMBER,

Line 1282: FROM ahl_ue_relationships

1278: FROM ahl_unit_effectivities_app_v
1279: WHERE (status_code not in ('INIT-ACCOMPLISHED', 'TERMINATED', 'MR-TERMINATE', 'ACCOMPLISHED','SR-CLOSED','DEFERRED','CANCELLED') OR status_code IS NULL)
1280: AND unit_effectivity_id in (
1281: SELECT related_ue_id
1282: FROM ahl_ue_relationships
1283: START WITH ue_id = p_ue_id
1284: AND relationship_code = 'PARENT'
1285: CONNECT BY ue_id = PRIOR related_ue_id
1286: AND relationship_code = 'PARENT');

Line 1380: FROM AHL_UE_RELATIONSHIPS

1376:
1377: -- Added to validate if UE ID is a child UE.
1378: CURSOR l_child_mr_csr(p_ue_id IN NUMBER) IS
1379: SELECT 'x'
1380: FROM AHL_UE_RELATIONSHIPS
1381: WHERE related_ue_id = p_ue_id;
1382:
1383: l_prev_status VARCHAR2(30);
1384: l_prev_object_version_no NUMBER;

Line 2270: FROM ahl_ue_relationships

2266: FOR UPDATE OF OBJECT_VERSION_NUMBER;
2267:
2268: CURSOR l_get_descendents(p_ue_id IN NUMBER) IS
2269: SELECT related_ue_id
2270: FROM ahl_ue_relationships
2271: START WITH ue_id = p_ue_id
2272: AND relationship_code = 'PARENT'
2273: CONNECT BY ue_id = PRIOR related_ue_id
2274: AND relationship_code = 'PARENT';

Line 3887: AND not exists (select 'x' from ahl_ue_relationships where

3883: WHERE EFF.MR_HEADER_ID = p_header_id
3884: AND object_type = 'MR'
3885: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))
3886: AND (EFF.status_code is null or EFF.status_code = 'INIT-DUE')
3887: AND not exists (select 'x' from ahl_ue_relationships where
3888: related_ue_id = EFF.unit_effectivity_id)
3889: FOR UPDATE;
3890:
3891: l_ue_rec l_unit_effectivity_csr%ROWTYPE;

Line 3953: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL

3949: EFF.LAST_UPDATED_BY,
3950: EFF.LAST_UPDATE_LOGIN
3951: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
3952: WHERE EFF.UNIT_EFFECTIVITY_ID IN
3953: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL
3954: WHERE REL.ORIGINATOR_UE_ID = p_effectivity_id)
3955: FOR UPDATE;
3956: -- AND REL.UE_ID = EFF.UNIT_EFFECTIVITY_ID;
3957:

Line 3963: ahl_ue_relationships UER, ahl_unit_effectivities_b UE1

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')

Line 3980: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER

3976: AND UE1.mr_header_id = p_mr_header_id;
3977:
3978: CURSOR ahl_sr_ue_csr IS
3979: SELECT UER.related_ue_id
3980: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER
3981: WHERE UER.ue_id = UE.unit_effectivity_id
3982: AND UER.relationship_code = 'PARENT'
3983: AND UE.object_type = 'SR'
3984: AND (UE.status_code is null or UE.status_code = 'INIT-DUE');

Line 3991: FROM ahl_ue_relationships

3987:
3988:
3989: CURSOR get_descendents_csr(p_ue_id IN NUMBER) IS
3990: SELECT related_ue_id
3991: FROM ahl_ue_relationships
3992: START WITH ue_id = p_ue_id
3993: AND relationship_code = 'PARENT'
3994: CONNECT BY ue_id = PRIOR related_ue_id
3995: AND relationship_code = 'PARENT';

Line 4073: AND not exists (select 'x' from ahl_ue_relationships where

4069: AND EFF.CSI_ITEM_INSTANCE_ID = p_csi_item_instance_id
4070: AND object_type = 'MR'
4071: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))
4072: AND (EFF.status_code = 'MR-TERMINATE')
4073: AND not exists (select 'x' from ahl_ue_relationships where
4074: related_ue_id = EFF.unit_effectivity_id);
4075:
4076: l_copy_record BOOLEAN;
4077: l_copy_ud_record BOOLEAN;