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: -- SKPATHAK :: Bug 13574991 :: 16-FEB-2012 :: FPed all fixes on R121 codeline

Line 685: FROM AHL_VISIT_TASKS_B AVTB, AHL_WORKORDERS AWV

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

Line 856: SELECT * FROM AHL_VISIT_TASKS_B

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

Line 880: FROM ahl_visit_tasks_b

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

Line 1069: SELECT * FROM AHL_VISIT_TASKS_B

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

Line 1099: FROM ahl_visit_tasks_b

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

Line 1298: SELECT * FROM AHL_VISIT_TASKS_B

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