APPS.PA_TASKS_MAINT_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2465: FROM pa_expenditure_items_all pe

2461: IS
2462:
2463: CURSOR cur_date(l_task_id NUMBER, l_project_id NUMBER ) IS
2464: SELECT MAX(pe.expenditure_item_date) ei_date
2465: FROM pa_expenditure_items_all pe
2466: WHERE pe.task_id IN (SELECT p.task_id
2467: FROM pa_tasks p
2468: where p.project_id = l_project_id
2469: --Added by rtarway for bug 4242216

Line 2483: x_ei_date pa_expenditure_items_all.expenditure_item_date%TYPE ;

2479: CONNECT BY PRIOR p.task_id = p.parent_task_id
2480: and p.project_id = l_project_id)
2481: AND pe.project_id = l_project_id;
2482:
2483: x_ei_date pa_expenditure_items_all.expenditure_item_date%TYPE ;
2484:
2485: -- Bug 6633233
2486: l_task_num pa_proj_elements.element_number%type;
2487:

Line 2553: FROM pa_expenditure_items_all pe

2549: IS
2550:
2551: CURSOR cur_start_date(l_task_id NUMBER, l_project_id NUMBER) IS
2552: SELECT MIN(pe.expenditure_item_date) ei_date
2553: FROM pa_expenditure_items_all pe
2554: WHERE pe.task_id IN (
2555: SELECT p.task_id
2556: FROM pa_tasks p
2557: WHERE p.project_id = l_project_id

Line 2573: x_ei_min_date pa_expenditure_items_all.expenditure_item_date%TYPE ;

2569: AND p.project_id = l_project_id
2570: )
2571: and pe.project_id = l_project_id;
2572:
2573: x_ei_min_date pa_expenditure_items_all.expenditure_item_date%TYPE ;
2574:
2575: -- Bug 6633233
2576: l_task_num pa_proj_elements.element_number%type;
2577: