APPS.RCV_DISTRIBUTIONS_S dependencies on PA_PROJECTS_ALL

Line 179: from PA_PROJECTS_ALL p,

175: select P.SEGMENT1 PROJECT_NUMBER ,
176: T.TASK_NUMBER
177: into x_project_number,
178: x_task_number
179: from PA_PROJECTS_ALL p,
180: PA_TASKS T
181: where P.PROJECT_ID = T.PROJECT_ID
182: and p.project_id = x_project_id
183: and T.task_id = x_task_id;

Line 187: from PA_PROJECTS_ALL

183: and T.task_id = x_task_id;
184: ELSE
185: select SEGMENT1 PROJECT_NUMBER
186: into x_project_number
187: from PA_PROJECTS_ALL
188: where project_id = x_project_id;
189: END IF;
190:
191: EXCEPTION

Line 683: from PA_PROJECTS_ALL p,

679: select P.SEGMENT1 PROJECT_NUMBER ,
680: T.TASK_NUMBER
681: into x_project_number,
682: x_task_number
683: from PA_PROJECTS_ALL p,
684: PA_TASKS T
685: where P.PROJECT_ID = T.PROJECT_ID
686: and p.project_id = l_project_id
687: and T.task_id = l_task_id;

Line 691: from PA_PROJECTS_ALL

687: and T.task_id = l_task_id;
688: ELSE
689: select SEGMENT1 PROJECT_NUMBER
690: into x_project_number
691: from PA_PROJECTS_ALL
692: where project_id = l_project_id;
693: END IF;
694:
695: EXCEPTION

Line 848: from PA_PROJECTS_ALL p,

844: select P.SEGMENT1 PROJECT_NUMBER ,
845: T.TASK_NUMBER
846: into x_project_number,
847: x_task_number
848: from PA_PROJECTS_ALL p,
849: PA_TASKS T
850: where P.PROJECT_ID = T.PROJECT_ID
851: and p.project_id = x_project_id
852: and T.task_id = x_task_id;

Line 856: from PA_PROJECTS_ALL

852: and T.task_id = x_task_id;
853: ELSE
854: select SEGMENT1 PROJECT_NUMBER
855: into x_project_number
856: from PA_PROJECTS_ALL
857: where project_id = x_project_id;
858: END IF;
859:
860: EXCEPTION