DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 10883: FROM ap_invoice_distributions_all aid

10879:
10880: /*Adding new cursor for bug 10043448 */
10881: CURSOR cur_inv_date(x_task_id pa_tasks.task_id%type) IS
10882: SELECT MAX(EXPENDITURE_ITEM_DATE)
10883: FROM ap_invoice_distributions_all aid
10884: WHERE project_id = p_project_in.pa_project_id AND
10885: aid.task_id IN (SELECT p.task_id
10886: FROM pa_tasks p
10887: START WITH p.task_id= x_task_id