APPS.FII_FDHM_PKG dependencies on FII_FINANCIAL_DIMENSIONS_V

Line 394: FROM fii_financial_dimensions_v m

390: FROM fii_slg_assignments
391: WHERE source_ledger_group_id =source_lgr_group_id)
392: UNION
393: SELECT master_value_set_id flex_value_set_id1
394: FROM fii_financial_dimensions_v m
395: WHERE m.dimension_short_name = dim_short_name
396: ORDER BY flex_value_set_id1;
397:
398: BEGIN

Line 465: FROM fii_financial_dimensions_v m

461: WHERE source_ledger_group_id =source_lgr_group_id)
462: AND flex_value_set_id1 < value_set_id
463: UNION
464: SELECT master_value_set_id flex_value_set_id1
465: FROM fii_financial_dimensions_v m
466: WHERE m.dimension_short_name = dim_short_name
467: AND master_value_set_id < value_set_id
468: ORDER BY flex_value_set_id1;
469:

Line 512: FROM fii_financial_dimensions_v m

508: FROM fii_slg_assignments
509: WHERE source_ledger_group_id =source_lgr_group_id)
510: UNION
511: SELECT master_value_set_id flex_value_set_id1
512: FROM fii_financial_dimensions_v m
513: WHERE m.dimension_short_name = dim_short_name
514: ORDER BY flex_value_set_id1;
515:
516: BEGIN

Line 591: FROM fii_financial_dimensions_v m

587: FROM fii_slg_assignments
588: WHERE source_ledger_group_id =source_lgr_group_id))
589: OR flex_value_set_id =
590: (SELECT master_value_set_id
591: FROM fii_financial_dimensions_v m
592: WHERE m.dimension_short_name= dim_short_name);
593: */
594: SELECT flex_value_set_id,
595: flex_value_set_id,

Line 644: FROM fii_financial_dimensions_v m

640: FROM fii_slg_assignments
641: WHERE source_ledger_group_id =source_lgr_group_id)
642: OR flex_value_set_id1 in
643: (SELECT master_value_set_id
644: FROM fii_financial_dimensions_v m
645: WHERE m.dimension_short_name= r.dimension_short_name);
646: sid number;
647: BEGIN
648: FND_GLOBAL.APPS_INITIALIZE(user_id, resp_id, appl_id);

Line 896: FROM fii_financial_dimensions_v m

892: FROM fii_slg_assignments
893: WHERE source_ledger_group_id =source_lgr_group_id))
894: OR child_flex_value_set_id =
895: (SELECT master_value_set_id
896: FROM fii_financial_dimensions_v m
897: WHERE m.dimension_short_name= dim_short_name) );
898:
899: END delete_dim_value_sets;
900: