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.JG_JGZZGLJRB_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 76: GL_PERIOD_STATUSES GLP1,

72: GLP2.END_DATE,
73: GLP2.EFFECTIVE_PERIOD_NUM
74: INTO FP_START_DATE,F_PERIOD_NUM,TP_END_DATE,T_PERIOD_NUM
75: FROM
76: GL_PERIOD_STATUSES GLP1,
77: GL_PERIOD_STATUSES GLP2
78: WHERE GLP1.APPLICATION_ID = 101
79: AND GLP2.APPLICATION_ID = GLP1.APPLICATION_ID
80: AND GLP1.LEDGER_ID = P_LEDGER_ID

Line 77: GL_PERIOD_STATUSES GLP2

73: GLP2.EFFECTIVE_PERIOD_NUM
74: INTO FP_START_DATE,F_PERIOD_NUM,TP_END_DATE,T_PERIOD_NUM
75: FROM
76: GL_PERIOD_STATUSES GLP1,
77: GL_PERIOD_STATUSES GLP2
78: WHERE GLP1.APPLICATION_ID = 101
79: AND GLP2.APPLICATION_ID = GLP1.APPLICATION_ID
80: AND GLP1.LEDGER_ID = P_LEDGER_ID
81: AND GLP2.LEDGER_ID = GLP1.LEDGER_ID