APPS.PJM_PROJECT dependencies on PA_TASKS_ALL_EXPEND_V

Line 708: from pa_tasks_all_expend_v te

704: , decode(te.chargeable_flag ,
705: 'N' , 'GEN-TASK NOT CHARGEABLE' , null)
706: , trunc(te.start_date)
707: , trunc(te.completion_date)
708: from pa_tasks_all_expend_v te
709: where te.task_id = X_task_id
710: and te.project_id = X_project_id
711: and te.expenditure_org_id = L_operating_unit;
712:

Line 878: -- not not in pa_tasks_all_expend_v

874: fetch task into task_num , retcode , start_date , end_date;
875:
876: --
877: -- If the cursor returns nothing, then the task is
878: -- not not in pa_tasks_all_expend_v
879: --
880: if ( task%notfound ) then
881:
882: open base_task; -- Check if the task is in base table