APPS.PJM_PROJECT dependencies on PA_TASKS

Line 338: from pa_tasks

334: ) return varchar2 IS
335: L_task_num varchar2(25);
336: cursor C1 is
337: select task_number
338: from pa_tasks
339: where task_id = X_task_id;
340:
341: begin
342:

Line 362: from pa_tasks

358: ) return varchar2 IS
359: L_task_name varchar2(20);
360: cursor C1 is
361: select task_name
362: from pa_tasks
363: where task_id = X_task_id;
364:
365: begin
366:

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 718: from pa_tasks t

714: select t.task_number
715: , 'GEN-INVALID TASK'
716: , trunc(t.start_date)
717: , trunc(t.completion_date)
718: from pa_tasks t
719: where t.task_id = X_task_id
720: and t.project_id = X_project_id;
721:
722: begin

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