APPS.FUN_RECON_RPT_PKG dependencies on GL_LEDGERS

Line 30: gl_ledgers gl1,

26: ,gl1.accounted_period_type ACCOUNTED_PERIOD_TYPE
27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledgers gl1,
31: xle_entity_profiles le1,
32: gl_ledgers gl2,
33: xle_entity_profiles le2
34: WHERE fia1.ledger_id = gl1.ledger_id

Line 32: gl_ledgers gl2,

28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledgers gl1,
31: xle_entity_profiles le1,
32: gl_ledgers gl2,
33: xle_entity_profiles le2
34: WHERE fia1.ledger_id = gl1.ledger_id
35: AND fia1.from_le_id = le1.legal_entity_id
36: AND fia1.to_le_id = fia2.from_le_id

Line 66: gl_ledgers gl1,

62: ,glb1.period_name TRANSACTING_PERIOD_NAME
63: ,glp2.period_name TRADING_PERIOD_NAME
64: FROM fun_inter_accounts_v fia1,
65: gl_balances glb1,
66: gl_ledgers gl1,
67: xle_entity_profiles le1,
68: gl_periods glp1,
69: fun_inter_accounts_v fia2,
70: gl_ledgers gl2,

Line 70: gl_ledgers gl2,

66: gl_ledgers gl1,
67: xle_entity_profiles le1,
68: gl_periods glp1,
69: fun_inter_accounts_v fia2,
70: gl_ledgers gl2,
71: xle_entity_profiles le2,
72: gl_periods glp2
73: WHERE fia1.ledger_id = glb1.ledger_id
74: AND fia1.ccid = glb1.code_combination_id

Line 269: ,gl_ledgers gl

265: ,gl_je_headers gjh
266: ,gl_je_batches gjb
267: ,gl_periods glp
268: ,xla_subledgers xsrc
269: ,gl_ledgers gl
270: , ($get_accounts_query$) fun_act
271: WHERE aeh.accounting_entry_status_code = ''F''
272: AND aeh.gl_transfer_status_code = ''Y''
273: AND ael.ae_header_id = aeh.ae_header_id

Line 423: ,gl_ledgers gl

419: ,gl_ledger_le_v glv
420: ,fun_inter_accounts_v fia
421: ,gl_periods glp
422: ,xla_subledgers xsrc
423: ,gl_ledgers gl
424: WHERE aeh.accounting_entry_status_code = ''F''
425: AND aeh.gl_transfer_status_code = ''Y''
426: AND ael.ae_header_id = aeh.ae_header_id
427: AND ael.application_id = aeh.application_id

Line 1322: gl_ledgers gl

1318: IS
1319: SELECT glp.start_date,
1320: glp.end_date
1321: FROM gl_periods glp,
1322: gl_ledgers gl
1323: WHERE glp.period_set_name = gl.period_set_name
1324: AND glp.period_type = gl.accounted_period_type
1325: AND glp.period_name = p_period_name
1326: AND gl.ledger_id = p_ledger_id;

Line 1986: from gl_ledgers

1982: if (p_balance_type = 'R') then
1983:
1984: select CURRENCY_CODE
1985: INTO l_currency
1986: from gl_ledgers
1987: where ledger_id = p_trans_ledger_id;
1988:
1989: if( l_currency <> p_currency) THEN
1990:

Line 2033: from gl_ledgers

2029: elsif (p_balance_type = 'P') then
2030:
2031: select CURRENCY_CODE
2032: INTO l_currency
2033: from gl_ledgers
2034: where ledger_id = p_trad_ledger_id;
2035:
2036: if( l_currency <> p_currency) THEN
2037:

Line 2181: gl_ledgers gl

2177: -- get the end date of l_trans_gl_period for l_trans_ledger_id
2178: SELECT glp.end_date, glp.adjustment_period_flag
2179: INTO l_trans_gl_prd_end_date, l_trans_adj_period_flag
2180: FROM gl_periods glp,
2181: gl_ledgers gl
2182: WHERE glp.period_set_name = gl.period_set_name
2183: AND glp.period_type = gl.accounted_period_type
2184: AND glp.period_name = l_trans_gl_period
2185: AND gl.ledger_id = l_trans_ledger_id;

Line 2190: gl_ledgers gl

2186:
2187: SELECT glp.period_name
2188: INTO l_trad_gl_period
2189: FROM gl_periods glp,
2190: gl_ledgers gl
2191: WHERE glp.period_set_name = gl.period_set_name
2192: AND glp.period_type = gl.accounted_period_type
2193: AND gl.ledger_id = l_trad_ledger_id
2194: AND l_trans_gl_prd_end_date between glp.start_date and glp.end_date