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

Line 2110: FROM Gl_Period_Statuses GP

2106: l_period_end := P_PERIOD_TO;
2107:
2108: SELECT COUNT(*)
2109: INTO invalid_period_num
2110: FROM Gl_Period_Statuses GP
2111: WHERE GP.application_id = 101
2112: AND GP.ledger_id = p_ledger_id
2113: AND GP.start_date >=
2114: (SELECT START_DATE

Line 2115: FROM Gl_Period_Statuses

2111: WHERE GP.application_id = 101
2112: AND GP.ledger_id = p_ledger_id
2113: AND GP.start_date >=
2114: (SELECT START_DATE
2115: FROM Gl_Period_Statuses
2116: WHERE LEDGER_ID = l_ledger_id
2117: AND PERIOD_NAME = l_period_start
2118: AND APPLICATION_ID = 101)
2119: AND GP.end_date <=

Line 2121: FROM Gl_Period_Statuses

2117: AND PERIOD_NAME = l_period_start
2118: AND APPLICATION_ID = 101)
2119: AND GP.end_date <=
2120: (SELECT END_DATE
2121: FROM Gl_Period_Statuses
2122: WHERE LEDGER_ID = l_ledger_id
2123: AND PERIOD_NAME = l_period_end
2124: AND APPLICATION_ID = 101)
2125: AND (GP.closing_status <> 'P'