APPS.PA_OTC_API dependencies on PA_ONLINE_PROJECTS_V

Line 5612: Pa_Online_Projects_V

5608: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) Is
5609: Select
5610: Project_Number
5611: From
5612: Pa_Online_Projects_V
5613: Where
5614: Project_Id = P_Proj_Id; */
5615:
5616: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS

Line 5619: from Pa_Online_Projects_V pp,

5615:
5616: Cursor GetProjInfo(P_Proj_Id IN Pa_Projects_All.Project_Id%TYPE) IS
5617: select
5618: p.segment1
5619: from Pa_Online_Projects_V pp,
5620: pa_projects_all p
5621: where pp.Project_Id = P_Proj_Id
5622: and pp.project_id = p.project_id;
5623: /* end bug 4766396 */

Line 7472: -- Pa_Online_Projects_V

7468: -- Cursor ValidateProject ( P_Project_Id IN Pa_Projects_All.Project_Id%TYPE ) Is
7469: -- Select
7470: -- 'Y'
7471: -- From
7472: -- Pa_Online_Projects_V
7473: -- Where
7474: -- Project_Id = P_Project_Id;
7475:
7476: TYPE Day_Rec IS Record (