APPS.AHL_VWP_COST_PVT dependencies on AHL_VISIT_TASKS_B

Line 100: FROM ahl_visit_tasks_b

96: CURSOR c_child_tasks_cur (C_VISIT_ID IN NUMBER)
97: IS
98: SELECT visit_task_id,cost_parent_id,level,
99: task_type_code,originating_task_id
100: FROM ahl_visit_tasks_b
101: WHERE visit_id = C_VISIT_ID
102: AND NVL(status_code,'Y') <> 'DELETED'
103: START WITH cost_parent_id IS NULL
104: CONNECT BY PRIOR visit_task_id = cost_parent_id

Line 682: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV

678: -- To find out to find out all task's Workorder_Id within visit except those,
679: -- which have task_type_code = 'Summary' and MR_id is Null i.e manually created Summary task
680: CURSOR c_WO_tasks (x_id IN NUMBER) IS
681: SELECT AVTB.VISIT_TASK_ID, AWV.WORKORDER_ID
682: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV
683: WHERE AVTB.VISIT_TASK_ID = AWV.VISIT_TASK_ID
684: AND AVTB.VISIT_ID = x_id
685: AND NVL(AVTB.status_code, 'Y') <> NVL ('DELETED', 'X')
686: -- AND AWV.STATUS_CODE NOT IN ('22','7')

Line 853: SELECT * FROM AHL_VISIT_TASKS_B

849:
850: -- Define local Cursors
851: -- To find out viist's task details
852: CURSOR c_task(x_id IN NUMBER)IS
853: SELECT * FROM AHL_VISIT_TASKS_B
854: WHERE VISIT_TASK_ID = x_id;
855: c_task_rec c_task%ROWTYPE;
856:
857: -- yazhou 27-Jun-2006 starts

Line 877: FROM ahl_visit_tasks_b

873:
874: -- To find out all tasks under the given MR
875: CURSOR c_MR_task(x_id IN NUMBER) IS
876: SELECT visit_task_id
877: FROM ahl_visit_tasks_b
878: WHERE mr_id is not null
879: START WITH visit_task_id = x_id
880: CONNECT BY PRIOR visit_task_id = originating_task_id;
881: c_MR_task_rec c_MR_task%ROWTYPE;

Line 1066: SELECT * FROM AHL_VISIT_TASKS_B

1062:
1063: -- Define local cursors
1064: -- To find out viist's task details
1065: CURSOR c_task(x_id IN NUMBER)IS
1066: SELECT * FROM AHL_VISIT_TASKS_B
1067: WHERE VISIT_TASK_ID = x_id;
1068: c_task_rec c_task%ROWTYPE;
1069:
1070: -- yazhou 27-Jun-2006 starts

Line 1096: FROM ahl_visit_tasks_b

1092:
1093: -- To find out all tasks using the given task as cost parent
1094: CURSOR c_Cost_Parent_task(x_id IN NUMBER) IS
1095: SELECT visit_task_id
1096: FROM ahl_visit_tasks_b
1097: START WITH visit_task_id = x_id
1098: CONNECT BY PRIOR visit_task_id = cost_parent_id;
1099: c_Cost_Parent_task_rec c_Cost_Parent_task%ROWTYPE;
1100:

Line 1295: SELECT * FROM AHL_VISIT_TASKS_B

1291:
1292: -- Define local cursors
1293: -- To find out viist's task details
1294: CURSOR c_task(x_id IN NUMBER)IS
1295: SELECT * FROM AHL_VISIT_TASKS_B
1296: WHERE VISIT_TASK_ID = x_id;
1297: c_task_rec c_task%ROWTYPE;
1298:
1299: -- yazhou 27-Jun-2006 starts