APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 985: FROM AHL_UE_RELATIONSHIPS

981:
982:
983: CURSOR l_child_mr_csr(p_ue_id IN NUMBER) IS
984: SELECT 'x'
985: FROM AHL_UE_RELATIONSHIPS
986: WHERE related_ue_id = p_ue_id;
987:
988: CURSOR l_prior_initializations_csr(p_mr_id IN NUMBER,
989: p_item_instance_id IN NUMBER,

Line 1461: FROM ahl_ue_relationships

1457: FROM ahl_unit_effectivities_app_v
1458: WHERE (status_code not in ('INIT-ACCOMPLISHED', 'TERMINATED', 'MR-TERMINATE', 'ACCOMPLISHED','SR-CLOSED','DEFERRED','CANCELLED') OR status_code IS NULL)
1459: AND unit_effectivity_id in (
1460: SELECT related_ue_id
1461: FROM ahl_ue_relationships
1462: START WITH ue_id = p_ue_id
1463: AND relationship_code = 'PARENT'
1464: CONNECT BY ue_id = PRIOR related_ue_id
1465: AND relationship_code = 'PARENT');

Line 1571: FROM AHL_UE_RELATIONSHIPS

1567:
1568: -- Added to validate if UE ID is a child UE.
1569: CURSOR l_child_mr_csr(p_ue_id IN NUMBER) IS
1570: SELECT 'x'
1571: FROM AHL_UE_RELATIONSHIPS
1572: WHERE related_ue_id = p_ue_id;
1573:
1574: -- get mr title
1575: CURSOR get_title_csr(p_mr_id IN NUMBER) IS

Line 2579: FROM ahl_ue_relationships

2575: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
2576:
2577: CURSOR l_get_descendents(p_ue_id IN NUMBER) IS
2578: SELECT related_ue_id
2579: FROM ahl_ue_relationships
2580: START WITH ue_id = p_ue_id
2581: AND relationship_code = 'PARENT'
2582: CONNECT BY ue_id = PRIOR related_ue_id
2583: AND relationship_code = 'PARENT';

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

4197: WHERE EFF.MR_HEADER_ID = p_header_id
4198: AND object_type = 'MR'
4199: -- AND (EFF.status_code is null or EFF.status_code in ('INIT-DUE','DEFERRED'))
4200: AND (EFF.status_code is null or EFF.status_code = 'INIT-DUE')
4201: AND not exists (select 'x' from ahl_ue_relationships where
4202: related_ue_id = EFF.unit_effectivity_id)
4203: AND TRUNC(NVL(EFF.DUE_DATE,SYSDATE)) > TRUNC(p_mr_effective_to_date)
4204: FOR UPDATE NOWAIT;
4205:

Line 4268: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL

4264: EFF.LAST_UPDATED_BY,
4265: EFF.LAST_UPDATE_LOGIN
4266: FROM AHL_UNIT_EFFECTIVITIES_APP_V EFF
4267: WHERE EFF.UNIT_EFFECTIVITY_ID IN
4268: (SELECT REL.RELATED_UE_ID FROM AHL_UE_RELATIONSHIPS REL
4269: WHERE REL.ORIGINATOR_UE_ID = p_effectivity_id)
4270: FOR UPDATE NOWAIT;
4271: -- AND REL.UE_ID = EFF.UNIT_EFFECTIVITY_ID;
4272:

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

Line 4299: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER

4295: AND UE1.mr_header_id = p_mr_header_id;
4296:
4297: CURSOR ahl_sr_ue_csr IS
4298: SELECT UER.related_ue_id
4299: FROM ahl_unit_effectivities_app_v UE, ahl_ue_relationships UER
4300: WHERE UER.ue_id = UE.unit_effectivity_id
4301: AND UER.relationship_code = 'PARENT'
4302: AND UE.object_type = 'SR'
4303: AND (UE.status_code is null or UE.status_code = 'INIT-DUE');

Line 4311: FROM ahl_ue_relationships

4307:
4308:
4309: CURSOR get_descendents_csr(p_ue_id IN NUMBER) IS
4310: SELECT related_ue_id
4311: FROM ahl_ue_relationships
4312: START WITH ue_id = p_ue_id
4313: AND relationship_code = 'PARENT'
4314: CONNECT BY ue_id = PRIOR related_ue_id
4315: AND relationship_code = 'PARENT';

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

4392: AND (EFF.status_code = 'MR-TERMINATE')
4393: AND EFF.LAST_UPDATE_DATE >= p_rev_date -- changed so that copy doesnt happen
4394: -- if an instance becomes applicable again after
4395: -- deferral went through in past(not applicable when deferred)
4396: AND not exists (select 'x' from ahl_ue_relationships where
4397: related_ue_id = EFF.unit_effectivity_id);
4398:
4399: l_copy_record BOOLEAN;
4400: l_copy_ud_record BOOLEAN;