DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on PA_PROJECTS_ALL

Line 96: from PA_PROJECTS_ALL PPA,

92: select PPA.SEGMENT1 PROJECT_NUMBER ,
93: PT.TASK_NUMBER
94: into x_project_number,
95: x_task_number
96: from PA_PROJECTS_ALL PPA,
97: PA_TASKS PT
98: where PPA.PROJECT_ID = PT.PROJECT_ID
99: and PPA.project_id = x_project_id
100: and PT.task_id = x_task_id;

Line 112: from PA_PROJECTS_ALL

108:
109: Begin
110: select SEGMENT1 PROJECT_NUMBER
111: into x_project_number
112: from PA_PROJECTS_ALL
113: where project_id = X_project_id;
114: Exception
115: when no_data_found then
116: x_project_number := NULL;