APPS.AHL_VWP_PLAN_TASKS_PVT dependencies on AHL_VISIT_TASKS_VL

Line 1309: SELECT * FROM Ahl_Visit_Tasks_VL

1305: c_Visit_rec c_Visit%ROWTYPE;
1306:
1307: -- To find task related information
1308: CURSOR c_Task (x_id IN NUMBER) IS
1309: SELECT * FROM Ahl_Visit_Tasks_VL
1310: WHERE VISIT_TASK_ID = x_id;
1311: c_Task_rec c_Task%ROWTYPE;
1312: c_upd_Task_rec c_Task%ROWTYPE;
1313:

Line 1721: SELECT * FROM Ahl_Visit_Tasks_VL

1717: l_origin_id NUMBER;
1718:
1719: -- To find all tasks related information
1720: CURSOR c_Task (x_id IN NUMBER) IS
1721: SELECT * FROM Ahl_Visit_Tasks_VL
1722: WHERE Visit_Task_ID = x_id;
1723: c_task_rec c_Task%ROWTYPE;
1724: BEGIN
1725: --------------------- initialize -----------------------

Line 1924: FROM Ahl_Visit_Tasks_vl

1920: )
1921: IS
1922: CURSOR c_Visit_Task IS
1923: SELECT *
1924: FROM Ahl_Visit_Tasks_vl
1925: WHERE Visit_Task_ID = p_task_rec.Visit_Task_ID;
1926: --
1927: -- This is the only exception for using %ROWTYPE.
1928: -- We are selecting from the VL view, which may

Line 2026: 'Ahl_Visit_Tasks_vl',

2022: fnd_log.string(fnd_log.level_statement,'ahl.plsql.',': = Check_Visit_Task_UK_Items Uniqueness Of ID');
2023: END IF;
2024: -- FOR CREATION
2025: IF Ahl_Utility_Pvt.check_uniqueness(
2026: 'Ahl_Visit_Tasks_vl',
2027: 'Visit_Task_ID = ' || p_task_rec.Visit_Task_ID
2028: ) = Fnd_Api.g_false
2029: THEN
2030: Fnd_Message.set_name ('AHL', 'AHL_VWP_DUPLICATE_TASK_ID');