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.FUN_RECON_RPT_PKG dependencies on GL_LEDGERS

Line 1296: gl_ledgers gl

1292: IS
1293: SELECT glp.start_date,
1294: glp.end_date
1295: FROM gl_periods glp,
1296: gl_ledgers gl
1297: WHERE glp.period_set_name = gl.period_set_name
1298: AND glp.period_type = gl.accounted_period_type
1299: AND glp.period_name = p_period_name
1300: AND gl.ledger_id = p_ledger_id;

Line 2075: gl_ledgers gl

2071: -- get the end date of l_trans_gl_period for l_trans_ledger_id
2072: SELECT glp.end_date, glp.adjustment_period_flag
2073: INTO l_trans_gl_prd_end_date, l_trans_adj_period_flag
2074: FROM gl_periods glp,
2075: gl_ledgers gl
2076: WHERE glp.period_set_name = gl.period_set_name
2077: AND glp.period_type = gl.accounted_period_type
2078: AND glp.period_name = l_trans_gl_period
2079: AND gl.ledger_id = l_trans_ledger_id;

Line 2084: gl_ledgers gl

2080:
2081: SELECT glp.period_name
2082: INTO l_trad_gl_period
2083: FROM gl_periods glp,
2084: gl_ledgers gl
2085: WHERE glp.period_set_name = gl.period_set_name
2086: AND glp.period_type = gl.accounted_period_type
2087: AND gl.ledger_id = l_trad_ledger_id
2088: AND l_trans_gl_prd_end_date between glp.start_date and glp.end_date