APPS.FII_BUDGET_FORECAST_C dependencies on FII_SOURCE_LEDGER_GROUPS

Line 822: ' fii_slg_budget_asgns b, fii_source_ledger_groups slg '||

818: ' b.budget_version_id, '||
819: ' b.base_budget_version_id, '||
820: ' s.period_set_name, s.accounted_period_type '||
821: ' FROM gl_periods p, gl_ledgers_public_v s, '||
822: ' fii_slg_budget_asgns b, fii_source_ledger_groups slg '||
823: ' WHERE slg.usage_code = ''DBI'' '||
824: ' AND b.source_ledger_group_id = slg.source_ledger_group_id '||
825: ' AND s.ledger_id = b.ledger_id '||
826: ' AND p.start_date <= b.to_period_end_date '||

Line 841: ' fii_source_ledger_groups fslg, '||

837: ' slba.base_budget_version_id '||
838: ' FROM fii_slg_assignments slga, '||
839: ' gl_je_inclusion_rules rule, '||
840: ' fii_slg_budget_asgns slba, '||
841: ' fii_source_ledger_groups fslg, '||
842: ' gl_ledgers_public_v sob '||
843: ' WHERE slga.je_rule_set_id = rule.je_rule_set_id (+) '||
844: ' AND slga.source_ledger_group_id = fslg.source_ledger_group_id '||
845: ' AND fslg.usage_code = ''DBI'' '||

Line 870: ' fii_source_ledger_groups fslg2, '||

866: ' ) v1, '||
867: ' gl_je_lines line, '||
868: ' fii_gl_ccid_dimensions fin, '||
869: ' fii_slg_assignments slga2, '||
870: ' fii_source_ledger_groups fslg2, '||
871: ' fii_slg_budget_asgns b2, '||
872: ' fii_fin_cat_type_assgns fcta '||
873: ' WHERE v1.je_header_id = line.je_header_id '||
874: ' AND line.code_combination_id = fin.code_combination_id '||

Line 1076: ' FROM FII_SOURCE_LEDGER_GROUPS fslg, '||

1072: ' sum(NVL(b.begin_balance_cr,0) - NVL(b.begin_balance_dr,0)), '||
1073: ' 0), '||
1074: ' p.start_date, b.budget_version_id, '||
1075: ' b.code_combination_id, sysdate, :user_id, sysdate, :user_id, :login_id '||
1076: ' FROM FII_SOURCE_LEDGER_GROUPS fslg, '||
1077: ' FII_SLG_ASSIGNMENTS slga, '||
1078: ' FII_SLG_BUDGET_ASGNS slba, '||
1079: ' FII_GL_CCID_DIMENSIONS fin, '||
1080: ' FII_FIN_CAT_TYPE_ASSGNS fcta, '||

Line 1737: fii_source_ledger_groups fslg,

1733:
1734: CURSOR sobCursor (global_prim_curr VARCHAR2) IS
1735: SELECT DISTINCT sob.name, sob.currency_code
1736: FROM fii_slg_assignments slga,
1737: fii_source_ledger_groups fslg,
1738: gl_ledgers_public_v sob
1739: WHERE sob.ledger_id = slga.ledger_id
1740: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
1741: AND fslg.usage_code = 'DBI'