APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on AHL_VISIT_TASKS_B

Line 187: FROM ahl_visit_tasks_b

183:
184: CURSOR c_task_status(p_task_id IN NUMBER)
185: IS
186: select 'X'
187: FROM ahl_visit_tasks_b
188: WHERE visit_task_id = p_task_id
189: AND status_code = 'RELEASED';
190:
191: CURSOR c_task_type_code(p_task_id IN NUMBER)

Line 194: FROM ahl_visit_tasks_b

190:
191: CURSOR c_task_type_code(p_task_id IN NUMBER)
192: IS
193: select 'X'
194: FROM ahl_visit_tasks_b
195: WHERE visit_task_id = p_task_id
196: AND task_type_code = 'SUMMARY';
197:
198: -- As per latest Post 11.5.10 DLD if the task are in release status

Line 205: ahl_visit_tasks_b vt

201: /*CURSOR c_children_check_status(p_parent_visit_task_id IN NUMBER)
202: IS
203: SELECT 'X'
204: FROM ahl_task_links lin,
205: ahl_visit_tasks_b vt
206: WHERE lin.visit_task_id = vt.visit_task_id
207: AND vt.status_code = 'RELEASED'
208: START WITH lin.parent_task_id = p_parent_visit_task_id
209: CONNECT BY PRIOR lin.visit_task_id = lin.parent_task_id;

Line 214: FROM ahl_visit_tasks_b

210: */
211: CURSOR c_task_number(p_task_id IN NUMBER)
212: IS
213: SELECT VISIT_TASK_NUMBER
214: FROM ahl_visit_tasks_b
215: where visit_task_id = p_task_id;
216:
217: l_dummy VARCHAR2(1);
218: l_parent_task_number number;

Line 451: from AHL_VISIT_TASKS_B

447: FROM AHL_VISIT_TASKS_VL
448: WHERE VISIT_TASK_NUMBER=C_PARENT_TASK_NUMBER
449: AND SUMMARY_TASK_FLAG='N'
450: AND VISIT_ID = (select visit_id
451: from AHL_VISIT_TASKS_B
452: where VISIT_TASK_ID = c_visit_task_id);
453:
454: l_task_det get_task_info%rowtype;
455: BEGIN

Line 570: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and

566:
567: -- Modified by amagrawa
568: CURSOR CHECK_TASK_ID(C_TASK_NUMBER IN NUMBER, C_TASK_ID IN NUMBER)
569: IS
570: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and
571: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );
572:
573:
574:

Line 571: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );

567: -- Modified by amagrawa
568: CURSOR CHECK_TASK_ID(C_TASK_NUMBER IN NUMBER, C_TASK_ID IN NUMBER)
569: IS
570: select VISIT_TASK_ID from AHL_VISIT_TASKS_B where visit_task_number = C_TASK_NUMBER and
571: visit_id = (select visit_id from ahl_visit_tasks_b where visit_task_id = C_TASK_ID );
572:
573:
574:
575: l_flip_vtid NUMBER;

Line 837: FROM AHL_VISIT_TASKS_B

833: -- for finding the status of a task. Added in 11.5.10
834: -- amagrawa Modified the cursor declaration based on review comments.
835: CURSOR task_status_csr(p_task_id IN NUMBER) IS
836: SELECT STATUS_CODE
837: FROM AHL_VISIT_TASKS_B
838: WHERE VISIT_TASK_ID=p_task_id;
839: -- AND VISIT_TASK_NUMBER= p_task_no ;
840:
841: -- Cursor find all details about visit

Line 845: SELECT visit_id FROM AHL_VISIT_TASKS_B

841: -- Cursor find all details about visit
842: CURSOR c_Visit (p_task_id IN NUMBER) IS
843: SELECT Any_Task_Chg_Flag,visit_id FROM Ahl_Visits_VL
844: WHERE VISIT_ID = (
845: SELECT visit_id FROM AHL_VISIT_TASKS_B
846: WHERE visit_task_id = p_task_id
847: );
848:
849: l_visit_csr_rec c_Visit%ROWTYPE;