APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1461: SELECT * FROM Ahl_Visit_Tasks_VL

1457: c_Visit_rec c_Visit%ROWTYPE;
1458:
1459: -- To find task related information
1460: CURSOR c_Task (x_id IN NUMBER) IS
1461: SELECT * FROM Ahl_Visit_Tasks_VL
1462: WHERE VISIT_TASK_ID = x_id;
1463: c_Task_rec c_Task%ROWTYPE;
1464: c_upd_Task_rec c_Task%ROWTYPE;
1465:

Line 1946: SELECT * FROM Ahl_Visit_Tasks_VL

1942: l_origin_id NUMBER;
1943:
1944: -- To find all tasks related information
1945: CURSOR c_Task (x_id IN NUMBER) IS
1946: SELECT * FROM Ahl_Visit_Tasks_VL
1947: WHERE Visit_Task_ID = x_id;
1948: c_task_rec c_Task%ROWTYPE;
1949: BEGIN
1950: --------------------- initialize -----------------------

Line 2149: FROM Ahl_Visit_Tasks_vl

2145: )
2146: IS
2147: CURSOR c_Visit_Task IS
2148: SELECT *
2149: FROM Ahl_Visit_Tasks_vl
2150: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
2151: --
2152: -- This is the only exception for using %ROWTYPE.
2153: -- We are selecting from the VL view, which may

Line 2251: 'Ahl_Visit_Tasks_vl',

2247: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');
2248: END IF;
2249: -- FOR CREATION
2250: IF Ahl_Utility_Pvt.check_uniqueness(
2251: 'Ahl_Visit_Tasks_vl',
2252: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
2253: ) = Fnd_Api.g_false
2254: THEN
2255: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');