[Home] [Help]
1412: per2.start_date), --jeh.posted_date), -- for encumbrances
1413: null) -- for Commercial
1414: FROM (
1415: SELECT p.period_name, s.ledger_id
1416: FROM gl_periods p, gl_ledgers_public_v s
1417: WHERE p.start_date <= NVL(P_End_Date, start_date)
1418: AND p.end_date >= P_Start_Date
1419: AND p.period_set_name = s.period_set_name) per,
1420: (SELECT DISTINCT
1430: gl_je_headers jeh,
1431: fii_encum_type_mappings etype,
1432: fii_gl_processed_header_ids fgph,
1433: gl_periods per2,
1434: gl_ledgers_public_v s2
1435: WHERE jeh.ledger_id = fset.ledger_id
1436: AND jeh.encumbrance_type_id = etype.encumbrance_type_id (+)
1437: AND (jeh.je_source = fset.je_source_name OR fset.je_source_name = '-1')
1438: -- Bug 5026804: Exclude the journal source - Closing Journal
1576: g_fii_user_id || ',' ||
1577: g_fii_login_id || '
1578: FROM fii_gl_new_jrl_header_ids njhi,
1579: gl_je_lines line,
1580: gl_ledgers_public_v sob,
1581: fii_gl_ccid_dimensions fin,
1582: fii_slg_assignments slga,
1583: fii_source_ledger_groups fslg
1584: WHERE njhi.je_header_id = line.je_header_id
1984: ) jeb,
1985: financials_system_params_all org,
1986: (
1987: SELECT p.period_name, s.ledger_id
1988: FROM gl_periods p, gl_ledgers_public_v s
1989: WHERE p.start_date <= l_end_date
1990: AND p.end_date >= l_start_date
1991: AND p.period_set_name = s.period_set_name) per,
1992: (SELECT DISTINCT
2032: jeh.encumbrance_type_id, --Added for PSI
2033: jeh.actual_flag, --Added for PSI
2034: decode(g_industry, 'G', NVL(etype.encumbrance_type, 'OTHERS'),
2035: 'C', NULL) encumbrance_type
2036: FROM gl_ledgers_public_v s,
2037: gl_periods p,
2038: gl_periods p2,
2039: gl_je_headers jeh,
2040: fii_encum_type_mappings etype,
2079: SLGA2.bal_seg_value_id,
2080: SLGA2.chart_of_accounts_id,
2081: SOB.currency_code,
2082: SOB.CHART_OF_ACCOUNTS_ID chart_accs_id_sob
2083: FROM gl_ledgers_public_v SOB,
2084: FII_SLG_ASSIGNMENTS SLGA2,
2085: FII_SOURCE_LEDGER_GROUPS FSLG2
2086: WHERE SOB.LEDGER_ID = SLGA2.LEDGER_ID
2087: AND SLGA2.SOURCE_LEDGER_GROUP_ID = FSLG2.SOURCE_LEDGER_GROUP_ID
2880: -- global primary currency
2881: CURSOR fcurrCursor (global_prim_curr VARCHAR2) IS
2882: SELECT DISTINCT sob.name, t.functional_currency
2883: FROM fii_gl_enc_carryfwd_t t,
2884: gl_ledgers_public_v sob
2885: WHERE t.functional_currency NOT IN (global_prim_curr)
2886: AND t.ledger_id = sob.ledger_id;
2887:
2888: BEGIN
2981: ' NVL(b.begin_balance_cr, 0) - NVL(b.begin_balance_dr, 0)) '||
2982: ' other_amount_b, '||
2983: ' per.year_start_date '||
2984: 'FROM gl_balances b, '||
2985: ' gl_ledgers_public_v sob, '||
2986: ' gl_periods per, '||
2987: ' (SELECT /*+ full(slga) */ DISTINCT slga.ledger_id '||
2988: ' FROM fii_slg_assignments slga, '||
2989: ' fii_source_ledger_groups fslg '||