APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 560: FROM AHL_VISIT_TASKS_B

556: CURSOR c_unit (x_unit_id IN NUMBER) IS
557: SELECT VISIT_NUMBER
558: FROM AHL_VISITS_B
559: WHERE VISIT_ID IN ( SELECT DISTINCT VISIT_ID
560: FROM AHL_VISIT_TASKS_B
561: WHERE Unit_Effectivity_Id = x_unit_id
562: )
563: and status_code not in ('CANCELLED','DELETED');
564:

Line 604: FROM ahl_visit_tasks_b

600: /*NR-MR Changes - sowsubra */
601: CURSOR c_task_for_ue(p_visit_id IN NUMBER, p_ue_id IN NUMBER)
602: IS
603: SELECT visit_task_id
604: FROM ahl_visit_tasks_b
605: WHERE visit_id = p_visit_id
606: AND unit_effectivity_id = p_ue_id
607: AND NVL(status_code,'Y') <> 'DELETED';
608:

Line 612: FROM ahl_visit_tasks_b

608:
609: /* Cursor added by rnahata for Bug 6939329 */
610: CURSOR c_task_id_for_ue(c_visit_id IN NUMBER, c_ue_id IN NUMBER) IS
611: SELECT visit_task_id
612: FROM ahl_visit_tasks_b
613: WHERE visit_id = c_visit_id
614: AND unit_effectivity_id = c_ue_id
615: AND NVL(status_code, 'PLANNING') <> 'DELETED'
616: AND TASK_TYPE_CODE = 'SUMMARY';

Line 890: UPDATE AHL_VISIT_TASKS_B

886: ', return_status from AHL_VWP_RULES_PVT.Insert_Tasks: ' || l_return_status );
887: END IF;
888: IF (NVL(l_return_status,'x') = FND_API.G_RET_STS_SUCCESS AND l_task_id IS NOT NULL AND p_x_task_Rec.duration IS NOT NULL) THEN
889: -- Update the duration column for the Planned task as well as its parent summary task with the user entered Estimated Duration
890: UPDATE AHL_VISIT_TASKS_B
891: SET DURATION = p_x_task_Rec.duration
892: WHERE VISIT_TASK_ID IN(l_task_id,l_parent_task_id) ;
893: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
894: fnd_log.string(fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1165: FROM ahl_visit_tasks_b

1161:
1162: /*NR-MR Changes - sowsubra*/
1163: CURSOR c_task_for_ue(p_visit_id IN NUMBER, p_ue_id IN NUMBER) IS
1164: SELECT visit_task_id
1165: FROM ahl_visit_tasks_b
1166: WHERE visit_id = p_visit_id
1167: AND unit_effectivity_id = p_ue_id
1168: AND NVL(status_code,'Y') <> 'DELETED';
1169: c_task_for_ue_rec c_task_for_ue%ROWTYPE;