APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 479: FROM AHL_UE_RELATIONSHIPS AUR

475: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03
476: Modified the query to fetch same result Dec 20 2003 sjayacha */
477: CURSOR c_relation (x_ue_id IN NUMBER) IS
478: SELECT AUR.RELATED_UE_ID "UNIT_ID"
479: FROM AHL_UE_RELATIONSHIPS AUR
480: START WITH AUR.UE_ID IN (SELECT AUEB.unit_effectivity_id
481: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB
482: WHERE (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
483: AND AUEB.unit_effectivity_id = x_ue_id

Line 492: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB

488: -- Added by sjayacha for Servie Request Integration
489: -- To check whether any child UE exists
490: CURSOR c_check_child_ue(p_ue_id IN NUMBER) IS
491: SELECT 'X'
492: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB
493: WHERE AUR.ue_id = AUEB.unit_effectivity_id
494: AND (AUEB.status_code IS NULL OR AUEB.status_code = 'INIT-DUE')
495: AND AUR.ue_id = p_ue_id;
496:

Line 1063: FROM ahl_ue_relationships aur,

1059: AND aueb.mr_header_id = x_mr_header_id;
1060:
1061: CURSOR c_relation (x_ue_id IN NUMBER) IS
1062: SELECT aur.related_ue_id
1063: FROM ahl_ue_relationships aur,
1064: ahl_unit_effectivities_vl aueb
1065: WHERE aur.ue_id = x_ue_id
1066: AND aur.ue_id = aueb.unit_effectivity_id
1067: AND (aueb.status_code IS NULL OR aueb.status_code = 'INIT-DUE');