APPS.AHL_VWP_PROJ_PROD_PVT dependencies on PA_TASKS

Line 1597: FROM PA_TASKS

1593:
1594: -- To find tasks information for visit
1595: CURSOR c_task_proj (x_id IN NUMBER) IS
1596: SELECT TASK_ID, TASK_NUMBER
1597: FROM PA_TASKS
1598: WHERE PROJECT_ID = x_id;
1599: c_task_proj_rec c_task_proj%ROWTYPE;
1600:
1601: CURSOR c_pjm_param(x_proj_id IN NUMBER,x_org_id IN NUMBER) IS

Line 8874: PA_TASKS PAT

8870: CURSOR get_task_dates_cur(p_wo_id IN NUMBER) IS
8871: SELECT AVT.PROJECT_TASK_ID, AVT.START_DATE_TIME, AVT.END_DATE_TIME,
8872: PAT.DESCRIPTION -- Pass the old description back again
8873: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,
8874: PA_TASKS PAT
8875: WHERE WO.VISIT_TASK_ID = AVT.VISIT_TASK_ID AND
8876: WO.WORKORDER_ID = p_wo_id AND
8877: PAT.TASK_ID (+) = AVT.PROJECT_TASK_ID;
8878: get_task_dates_rec get_task_dates_cur%ROWTYPE;