APPS.FUN_RECON_RPT_PKG dependencies on XLE_ENTITY_PROFILES

Line 31: xle_entity_profiles le1,

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
35: AND fia1.from_le_id = le1.legal_entity_id

Line 33: xle_entity_profiles le2

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
37: AND fia1.from_le_id = fia2.to_le_id

Line 67: xle_entity_profiles le1,

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,
71: xle_entity_profiles le2,

Line 71: xle_entity_profiles le2,

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
75: AND fia1.type = ''R''

Line 1881: from xle_entity_profiles

1877: v_le_name varchar2(100);
1878: BEGIN
1879: select distinct name
1880: into v_le_name
1881: from xle_entity_profiles
1882: where legal_entity_id = p_le_id
1883: and rownum=1;
1884:
1885: return v_le_name;