APPS.PA_TASKS_MAINT_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2414: FROM pa_expenditure_items_all pe

2410: IS
2411:
2412: CURSOR cur_date(l_task_id NUMBER, l_project_id NUMBER ) IS
2413: SELECT MAX(pe.expenditure_item_date) ei_date
2414: FROM pa_expenditure_items_all pe
2415: WHERE pe.task_id IN (SELECT p.task_id
2416: FROM pa_tasks p
2417: where p.project_id = l_project_id
2418: --Added by rtarway for bug 4242216

Line 2432: x_ei_date pa_expenditure_items_all.expenditure_item_date%TYPE ;

2428: CONNECT BY PRIOR p.task_id = p.parent_task_id
2429: and p.project_id = l_project_id)
2430: AND pe.project_id = l_project_id;
2431:
2432: x_ei_date pa_expenditure_items_all.expenditure_item_date%TYPE ;
2433:
2434: BEGIN
2435:
2436: OPEN cur_date(p_task_id, p_project_id);

Line 2486: FROM pa_expenditure_items_all pe

2482: IS
2483:
2484: CURSOR cur_start_date(l_task_id NUMBER, l_project_id NUMBER) IS
2485: SELECT MIN(pe.expenditure_item_date) ei_date
2486: FROM pa_expenditure_items_all pe
2487: WHERE pe.task_id IN (
2488: SELECT p.task_id
2489: FROM pa_tasks p
2490: WHERE p.project_id = l_project_id

Line 2506: x_ei_min_date pa_expenditure_items_all.expenditure_item_date%TYPE ;

2502: AND p.project_id = l_project_id
2503: )
2504: and pe.project_id = l_project_id;
2505:
2506: x_ei_min_date pa_expenditure_items_all.expenditure_item_date%TYPE ;
2507:
2508: BEGIN
2509:
2510: OPEN cur_start_date(p_task_id, p_project_id);