APPS.RCV_DISTRIBUTIONS_S dependencies on PA_PROJECTS_ALL

Line 230: from PA_PROJECTS_ALL p,

226: select P.SEGMENT1 PROJECT_NUMBER ,
227: T.TASK_NUMBER
228: into x_project_number,
229: x_task_number
230: from PA_PROJECTS_ALL p,
231: PA_TASKS T
232: where P.PROJECT_ID = T.PROJECT_ID
233: and p.project_id = x_project_id
234: and T.task_id = x_task_id;

Line 238: from PA_PROJECTS_ALL

234: and T.task_id = x_task_id;
235: ELSE
236: select SEGMENT1 PROJECT_NUMBER
237: into x_project_number
238: from PA_PROJECTS_ALL
239: where project_id = x_project_id;
240: END IF;
241:
242: EXCEPTION

Line 734: from PA_PROJECTS_ALL p,

730: select P.SEGMENT1 PROJECT_NUMBER ,
731: T.TASK_NUMBER
732: into x_project_number,
733: x_task_number
734: from PA_PROJECTS_ALL p,
735: PA_TASKS T
736: where P.PROJECT_ID = T.PROJECT_ID
737: and p.project_id = l_project_id
738: and T.task_id = l_task_id;

Line 742: from PA_PROJECTS_ALL

738: and T.task_id = l_task_id;
739: ELSE
740: select SEGMENT1 PROJECT_NUMBER
741: into x_project_number
742: from PA_PROJECTS_ALL
743: where project_id = l_project_id;
744: END IF;
745:
746: EXCEPTION

Line 899: from PA_PROJECTS_ALL p,

895: select P.SEGMENT1 PROJECT_NUMBER ,
896: T.TASK_NUMBER
897: into x_project_number,
898: x_task_number
899: from PA_PROJECTS_ALL p,
900: PA_TASKS T
901: where P.PROJECT_ID = T.PROJECT_ID
902: and p.project_id = x_project_id
903: and T.task_id = x_task_id;

Line 907: from PA_PROJECTS_ALL

903: and T.task_id = x_task_id;
904: ELSE
905: select SEGMENT1 PROJECT_NUMBER
906: into x_project_number
907: from PA_PROJECTS_ALL
908: where project_id = x_project_id;
909: END IF;
910:
911: EXCEPTION