DBA Data[Home] [Help]

APPS.PA_OTC_API dependencies on PA_ONLINE_PROJECTS_V

Line 6079: Pa_Online_Projects_V

6075: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) Is
6076: Select
6077: Project_Number
6078: From
6079: Pa_Online_Projects_V
6080: Where
6081: Project_Id = P_Proj_Id; */
6082:
6083: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS

Line 6086: from Pa_Online_Projects_V pp,

6082:
6083: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS
6084: select
6085: p.segment1
6086: from Pa_Online_Projects_V pp,
6087: pa_projects_all p
6088: where pp.Project_Id = P_Proj_Id
6089: and pp.project_id = p.project_id;
6090: /* end bug 4766396 */

Line 8355: -- Pa_Online_Projects_V

8351: -- Cursor ValidateProject ( P_Project_Id IN Pa_Projects_All.Project_Id%TYPE ) Is
8352: -- Select
8353: -- 'Y'
8354: -- From
8355: -- Pa_Online_Projects_V
8356: -- Where
8357: -- Project_Id = P_Project_Id;
8358:
8359: TYPE Day_Rec IS Record (