eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on GL_PERIODS

Line 5212: GL_PERIODS GLP ,

5208: PAP.END_DATE ,
5209: GLP.START_DATE ,
5210: GLP.END_DATE
5211: FROM PA_PERIODS_ALL PAP ,
5212: GL_PERIODS GLP ,
5213: GL_SETS_OF_BOOKS GSOB ,
5214: PA_IMPLEMENTATIONS_ALL PAIMP
5215: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
5216: AND GLP.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME

Line 5255: -- 1) GL periods (week) have lesser time unit than PA period (month)

5251: GROUP BY GL_PERIOD_NAME
5252: );
5253: ELSE
5254: -- two cases where l_is_gl_greater is 'N'
5255: -- 1) GL periods (week) have lesser time unit than PA period (month)
5256: -- 2) GL periods (month) have same time unit as PA period (month)
5257: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5258: SET multiplier =
5259: (SELECT COUNT(*)

Line 5256: -- 2) GL periods (month) have same time unit as PA period (month)

5252: );
5253: ELSE
5254: -- two cases where l_is_gl_greater is 'N'
5255: -- 1) GL periods (week) have lesser time unit than PA period (month)
5256: -- 2) GL periods (month) have same time unit as PA period (month)
5257: UPDATE PA_GL_PA_PERIODS_TMP tmp1
5258: SET multiplier =
5259: (SELECT COUNT(*)
5260: FROM PA_GL_PA_PERIODS_TMP tmp2