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_AP_VALIDATION_PKG dependencies on GL_PERIODS

Line 208: Gl_Periods Gp,

204: Gl_Je_Headers Jeh,
205: Gl_Import_References Gir,
206: Ja_Cn_Code_Combination_v Jcc,
207: Gl_Ledgers Gl,
208: Gl_Periods Gp,
209: Xla_Ae_Lines Ael,
210: Xla_Ae_Headers Aeh,
211: Ap_Suppliers Sup,
212: Xla_Transaction_Entities Ent,

Line 228: FROM Gl_Periods Gp1

224: AND Gl.accounted_period_type = Gp.period_type
225: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
226: AND Gp.start_date BETWEEN
227: (SELECT Gp1.Start_Date
228: FROM Gl_Periods Gp1
229: WHERE Gl.period_set_name = Gp1.period_set_name
230: AND Gl.accounted_period_type = Gp1.period_type
231: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
232: AND (SELECT Gp2.Start_Date

Line 233: FROM Gl_Periods Gp2

229: WHERE Gl.period_set_name = Gp1.period_set_name
230: AND Gl.accounted_period_type = Gp1.period_type
231: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
232: AND (SELECT Gp2.Start_Date
233: FROM Gl_Periods Gp2
234: WHERE Gl.period_set_name = Gp2.period_set_name
235: AND Gl.accounted_period_type = Gp2.period_type
236: AND Gp2.period_name = pv_period_to) --parameter: pv_period_to
237: --SLA condition

Line 277: Gl_Periods Gp,

273: Gl_Je_Headers Jeh,
274: Gl_Import_References Gir,
275: Ja_Cn_Code_Combination_v Jcc,
276: Gl_Ledgers Gl,
277: Gl_Periods Gp,
278: Xla_Ae_Lines Ael,
279: Xla_Ae_Headers Aeh,
280: Ap_Suppliers Sup
281: WHERE Jel.Je_Header_Id = Jeh.Je_Header_Id

Line 296: FROM Gl_Periods Gp1

292: AND Gl.accounted_period_type = Gp.period_type
293: AND Gp.period_year = to_number(pv_accounting_year) --parameter: pv_accounting_year
294: AND Gp.start_date BETWEEN
295: (SELECT Gp1.Start_Date
296: FROM Gl_Periods Gp1
297: WHERE Gl.period_set_name = Gp1.period_set_name
298: AND Gl.accounted_period_type = Gp1.period_type
299: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
300: AND (SELECT Gp2.Start_Date

Line 301: FROM Gl_Periods Gp2

297: WHERE Gl.period_set_name = Gp1.period_set_name
298: AND Gl.accounted_period_type = Gp1.period_type
299: AND Gp1.period_name = pv_period_from) --parameter: pv_period_from
300: AND (SELECT Gp2.Start_Date
301: FROM Gl_Periods Gp2
302: WHERE Gl.period_set_name = Gp2.period_set_name
303: AND Gl.accounted_period_type = Gp2.period_type
304: AND Gp2.period_name = pv_period_to) --parameter: pv_period_to
305: --SLA condition