APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 549: FROM AHL_VISIT_TASKS_B

545: CURSOR c_unit (x_unit_id IN NUMBER) IS
546: SELECT VISIT_NUMBER
547: FROM AHL_VISITS_B
548: WHERE VISIT_ID IN ( SELECT DISTINCT VISIT_ID
549: FROM AHL_VISIT_TASKS_B
550: WHERE Unit_Effectivity_Id = x_unit_id
551: )
552: and status_code not in ('CANCELLED','DELETED');
553:

Line 593: FROM ahl_visit_tasks_b

589: /*NR-MR Changes - sowsubra */
590: CURSOR c_task_for_ue(p_visit_id IN NUMBER, p_ue_id IN NUMBER)
591: IS
592: SELECT visit_task_id
593: FROM ahl_visit_tasks_b
594: WHERE visit_id = p_visit_id
595: AND unit_effectivity_id = p_ue_id
596: AND NVL(status_code,'Y') <> 'DELETED';
597:

Line 601: FROM ahl_visit_tasks_b

597:
598: /* Cursor added by rnahata for Bug 6939329 */
599: CURSOR c_task_id_for_ue(c_visit_id IN NUMBER, c_ue_id IN NUMBER) IS
600: SELECT visit_task_id
601: FROM ahl_visit_tasks_b
602: WHERE visit_id = c_visit_id
603: AND unit_effectivity_id = c_ue_id
604: AND NVL(status_code, 'PLANNING') <> 'DELETED'
605: AND TASK_TYPE_CODE = 'SUMMARY';

Line 1073: FROM ahl_visit_tasks_b

1069:
1070: /*NR-MR Changes - sowsubra*/
1071: CURSOR c_task_for_ue(p_visit_id IN NUMBER, p_ue_id IN NUMBER) IS
1072: SELECT visit_task_id
1073: FROM ahl_visit_tasks_b
1074: WHERE visit_id = p_visit_id
1075: AND unit_effectivity_id = p_ue_id
1076: AND NVL(status_code,'Y') <> 'DELETED';
1077: c_task_for_ue_rec c_task_for_ue%ROWTYPE;