APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_UE_RELATIONSHIPS

Line 490: FROM AHL_UE_RELATIONSHIPS AUR

486: /* For Bug# 3152532 fix by shbhanda dated 02-Dec-03
487: Modified the query to fetch same result Dec 20 2003 sjayacha */
488: CURSOR c_relation (x_ue_id IN NUMBER) IS
489: SELECT AUR.RELATED_UE_ID "UNIT_ID"
490: FROM AHL_UE_RELATIONSHIPS AUR
491: START WITH AUR.UE_ID IN (SELECT AUEB.unit_effectivity_id
492: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB
493: WHERE (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
494: AND AUEB.unit_effectivity_id = x_ue_id

Line 503: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB

499: -- Added by sjayacha for Servie Request Integration
500: -- To check whether any child UE exists
501: CURSOR c_check_child_ue(p_ue_id IN NUMBER) IS
502: SELECT 'X'
503: FROM ahl_ue_relationships AUR, ahl_unit_effectivities_vl AUEB
504: WHERE AUR.ue_id = AUEB.unit_effectivity_id
505: AND (AUEB.status_code IS NULL OR AUEB.status_code = 'INIT-DUE')
506: AND AUR.ue_id = p_ue_id;
507:

Line 1155: FROM ahl_ue_relationships aur,

1151: AND aueb.mr_header_id = x_mr_header_id;
1152:
1153: CURSOR c_relation (x_ue_id IN NUMBER) IS
1154: SELECT aur.related_ue_id
1155: FROM ahl_ue_relationships aur,
1156: ahl_unit_effectivities_vl aueb
1157: WHERE aur.ue_id = x_ue_id
1158: AND aur.ue_id = aueb.unit_effectivity_id
1159: AND (aueb.status_code IS NULL OR aueb.status_code = 'INIT-DUE');