APPS.FII_BUDGET_FORECAST_C dependencies on FII_SLG_ASSIGNMENTS

Line 838: ' FROM fii_slg_assignments slga, '||

834: ' DECODE(slga.je_rule_set_id, NULL, ''-1'', '||
835: ' rule.JE_CATEGORY_NAME) je_category_name, '||
836: ' slba.budget_version_id, '||
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 '||

Line 869: ' fii_slg_assignments slga2, '||

865: ' AND jeh.posted_date between p2.start_date and p2.end_date '||
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 '||

Line 1077: ' FII_SLG_ASSIGNMENTS slga, '||

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, '||
1081: ' GL_BALANCES b, '||

Line 1736: FROM fii_slg_assignments slga,

1732: l_row_exists NUMBER;
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

Line 2479: FROM FII_SLG_ASSIGNMENTS))

2475: FROM FII_BUDGET_INTERFACE b
2476: WHERE (b.ledger IS NOT NULL AND b.ledger_id IS NULL) OR
2477: (nvl(b.ledger_id, -1) NOT IN (
2478: SELECT ledger_id
2479: FROM FII_SLG_ASSIGNMENTS))
2480: FOR UPDATE OF STATUS_CODE;
2481:
2482: -- This is the cursor that print out all null company id
2483: CURSOR csr_null_com_id IS

Line 7406: FROM fii_slg_assignments ));

7402: WHERE ledger_id IN (
7403: SELECT DISTINCT ledger_id
7404: FROM fii_budget_base
7405: WHERE ledger_id NOT IN (SELECT ledger_id
7406: FROM fii_slg_assignments ));
7407:
7408: IF (FIIBUUP_DEBUG) THEN
7409: FII_MESSAGE.Write_Log
7410: (msg_name => 'FII_DEL_REC',