APPS.PA_RETENTION_UTIL dependencies on PA_TASKS

Line 1113: FROM pa_tasks old, pa_tasks new

1109: --dbms_output.put_line ('in get corresponding task');
1110:
1111: SELECT new.task_id, new.start_date, old.start_date
1112: INTO x_task_id, x_to_start_date, x_fr_start_date
1113: FROM pa_tasks old, pa_tasks new
1114: WHERE old.project_id = p_fr_project_id
1115: AND old.task_id = p_fr_task_id
1116: AND old.task_number = new.task_number
1117: AND new.project_id = p_to_project_id;

Line 1296: FROM pa_tasks

1292:
1293: -- use min(start_date) as pseudo original project start
1294:
1295: CURSOR c2 is SELECT min(start_date) min_start
1296: FROM pa_tasks
1297: WHERE project_id = p_fr_project_id;
1298:
1299: c2_rec c2%rowtype;
1300:

Line 2187: FROM pa_tasks

2183: BEGIN
2184:
2185: SELECT top_task_id
2186: INTO x_task_id
2187: FROM pa_tasks
2188: WHERE project_id = p_project_id
2189: AND task_id = top_task_id
2190: AND task_name = p_task_name;
2191:

Line 2214: FROM pa_tasks

2210:
2211:
2212: SELECT top_task_id
2213: INTO x_task_id
2214: FROM pa_tasks
2215: WHERE project_id = p_project_id
2216: AND task_id = top_task_id
2217: AND task_number = p_task_no;
2218:

Line 2242: FROM pa_tasks

2238:
2239:
2240: SELECT top_task_id
2241: INTO l_name_task_id
2242: FROM pa_tasks
2243: WHERE project_id = p_project_id
2244: AND task_id = top_task_id
2245: AND task_name = p_task_name;
2246:

Line 2262: FROM pa_tasks

2258:
2259:
2260: SELECT top_task_id
2261: INTO l_no_task_id
2262: FROM pa_tasks
2263: WHERE project_id = p_project_id
2264: AND task_id = top_task_id
2265: AND task_number = p_task_no;
2266:

Line 2693: FROM PA_TASKS

2689:
2690: BEGIN
2691: SELECT Task_ID
2692: INTO X_Task_ID
2693: FROM PA_TASKS
2694: WHERE Project_ID = P_Project_ID
2695: AND upper(Task_Number) = upper(P_Task_Number)
2696: AND upper(Task_Name) = upper(P_Task_Name) ;
2697: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS;