DBA Data[Home] [Help]

APPS.FII_BUDGET_FORECAST_C dependencies on FII_FINANCIAL_DIMENSIONS

Line 757: FROM FII_FINANCIAL_DIMENSIONS

753:
754: -- Check if UDD1 is enabled or not
755: SELECT DBI_ENABLED_FLAG
756: INTO l_udd1_enabled_flag
757: FROM FII_FINANCIAL_DIMENSIONS
758: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
759:
760: g_phase := 'PSI Insert Staging';
761:

Line 1025: FROM FII_FINANCIAL_DIMENSIONS

1021:
1022: -- Check if UDD1 is enabled or not
1023: SELECT DBI_ENABLED_FLAG
1024: INTO l_udd1_enabled_flag
1025: FROM FII_FINANCIAL_DIMENSIONS
1026: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
1027:
1028: g_phase := 'PSI Carry Forward';
1029:

Line 2270: FROM FII_FINANCIAL_DIMENSIONS

2266: -- Check if UDD1 is enabled or not
2267:
2268: SELECT DBI_ENABLED_FLAG
2269: INTO l_udd1_enabled_flag
2270: FROM FII_FINANCIAL_DIMENSIONS
2271: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
2272:
2273: IF (l_udd1_enabled_flag = 'Y') THEN
2274: -- UDD1 is enabled. Perform value to ID conversion.

Line 3471: FROM FII_FINANCIAL_DIMENSIONS

3467:
3468: -- Check if product category dimension is enabled or not.
3469: SELECT DBI_ENABLED_FLAG
3470: INTO l_pcat_enabled_flag
3471: FROM FII_FINANCIAL_DIMENSIONS
3472: WHERE dimension_short_name = 'ENI_ITEM_VBH_CAT';
3473:
3474: IF (l_pcat_enabled_flag = 'Y') THEN
3475: SELECT structure_id INTO p_mtc_structure_id