DBA Data[Home] [Help]

APPS.PA_MC_UPG dependencies on PA_PROJECT_STATUSES

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'