APPS.PA_MC_UPG dependencies on PA_PROJECTS

Line 100: FROM PA_PROJECT_STATUSES ST,PA_PROJECTS PROJ

96: WHERE set_of_books_id = G_Pri_SOB_ID;
97:
98: CURSOR C_Projects IS
99: SELECT Proj.Project_ID
100: FROM PA_PROJECT_STATUSES ST,PA_PROJECTS PROJ
101: WHERE PROJ.segment1 between G_From_Prj_Num and G_To_Prj_Num
102: AND (G_First_MRC_Period_Flag = 'N'
103: OR
104: (G_First_MRC_Period_Flag = 'Y'

Line 427: across Orgs. Hence PA_Projects_ALL used.

423: -----------------------------------------------------------------------
424: /** Get_Project_Number : Function to get the project number MIN or MAX.
425: x_Project_Range can be MIN or MAX. Accordingly, a minimum or
426: a maximum project number is returned. Project Number is Unique
427: across Orgs. Hence PA_Projects_ALL used.
428: Returns Project number if successful.
429: Returns -1 if Project number cannot be obtained.
430:
431: Returns -2 if MIN or MAX not specified.

Line 1210: FROM PA_PROJECTS PROJ,

1206:
1207: Cursor C_Project_Type
1208: IS
1209: SELECT TYP.CC_PRVDR_FLAG
1210: FROM PA_PROJECTS PROJ,
1211: PA_PROJECT_TYPES TYP
1212: WHERE TYP.PROJECT_TYPE = PROJ.PROJECT_TYPE
1213: AND PROJ.PROJECT_ID = p_PROJECT_ID;
1214: