APPS.PA_PROJECTS_MAINT_UTILS dependencies on PA_TASKS

Line 642: FROM pa_expenditure_items pai, --Bug#3088387pa_tasks t,

638: RETURN VARCHAR2 IS
639: CURSOR class_cdl (c_project_id NUMBER)
640: IS
641: SELECT '1'
642: FROM pa_expenditure_items pai, --Bug#3088387pa_tasks t,
643: pa_cost_distribution_lines pcd
644: WHERE pai.project_id=c_project_id AND --Bug#3088387t.task_id AND
645: pai.expenditure_item_id=pcd.expenditure_item_id ;
646: -- Bug#3088387AND t.project_id=c_project_id;

Line 718: if p_object_type = 'PA_TASKS' then

714: l_rec_Status_flag VARCHAR2(1);
715: l_project_id NUMBER;
716: BEGIN
717: x_return_status := 'S';
718: if p_object_type = 'PA_TASKS' then
719: SELECT project_id
720: INTO l_project_id
721: FROM pa_tasks
722: WHERE task_id = p_object_id;

Line 721: FROM pa_tasks

717: x_return_status := 'S';
718: if p_object_type = 'PA_TASKS' then
719: SELECT project_id
720: INTO l_project_id
721: FROM pa_tasks
722: WHERE task_id = p_object_id;
723: else
724: l_project_id := p_object_id;
725: end if;

Line 1860: pa_tasks t,

1856: FROM sys.dual
1857: WHERE EXISTS
1858: (SELECT NULL
1859: FROM pa_expenditure_items_all pai,
1860: pa_tasks t,
1861: pa_cost_distribution_lines_all pcd
1862: WHERE pai.task_id = t.task_id
1863: AND pai.expenditure_item_id = pcd.expenditure_item_id
1864: AND t.project_id = p_project_id);