APPS.FII_FDHM_PKG dependencies on FII_DIM_MAPPING_RULES

Line 385: FROM fii_dim_mapping_rules r

381: fdvsid NUMBER;
382:
383: CURSOR find_dim_value_sets_cur IS
384: SELECT flex_value_set_id1
385: FROM fii_dim_mapping_rules r
386: WHERE r.dimension_short_name = dim_short_name
387: AND flex_value_set_id1 is not null
388: AND r.chart_of_accounts_id in
389: (SELECT chart_of_accounts_id

Line 455: FROM fii_dim_mapping_rules r

451: fdvsid NUMBER;
452:
453: CURSOR find_dim_value_sets_cur IS
454: SELECT flex_value_set_id1
455: FROM fii_dim_mapping_rules r
456: WHERE r.dimension_short_name = dim_short_name
457: AND flex_value_set_id1 is not null
458: AND r.chart_of_accounts_id in
459: (SELECT chart_of_accounts_id

Line 503: FROM fii_dim_mapping_rules r

499: success boolean;
500:
501: CURSOR find_dim_value_sets_cur IS
502: SELECT flex_value_set_id1
503: FROM fii_dim_mapping_rules r
504: WHERE r.dimension_short_name = dim_short_name
505: AND flex_value_set_id1 is not null
506: AND r.chart_of_accounts_id in
507: (SELECT chart_of_accounts_id

Line 583: FROM fii_dim_mapping_rules r

579: last_update_login
580: FROM FND_FLEX_VALUE_NORM_HIERARCHY
581: WHERE flex_value_set_id in
582: (SELECT r.flex_value_set_id1
583: FROM fii_dim_mapping_rules r
584: WHERE r.dimension_short_name = dim_short_name
585: AND r.chart_of_accounts_id in
586: (SELECT chart_of_accounts_id
587: FROM fii_slg_assignments

Line 608: FROM fii_dim_mapping_rules r,

604: last_update_login
605: FROM FND_FLEX_VALUE_NORM_HIERARCHY,
606: (
607: SELECT r.flex_value_set_id1 vs_id
608: FROM fii_dim_mapping_rules r,
609: (SELECT distinct chart_of_accounts_id
610: FROM fii_slg_assignments
611: WHERE source_ledger_group_id = source_lgr_group_id) s
612: WHERE r.dimension_short_name = dim_short_name

Line 636: FROM fii_dim_mapping_rules r

632: success boolean :=true;
633:
634: CURSOR find_dim_value_sets_cur IS
635: SELECT flex_value_set_id1
636: FROM fii_dim_mapping_rules r
637: WHERE r.dimension_short_name = dim_short_name
638: AND r.chart_of_accounts_id in
639: (SELECT chart_of_accounts_id
640: FROM fii_slg_assignments

Line 888: FROM fii_dim_mapping_rules r

884: DELETE FROM fii_dim_norm_hierarchy
885: WHERE parent_flex_value_set_id = child_flex_value_set_id
886: AND ( child_flex_value_set_id in
887: (SELECT r.flex_value_set_id1
888: FROM fii_dim_mapping_rules r
889: WHERE r.dimension_short_name = dim_short_name
890: AND r.chart_of_accounts_id in
891: (SELECT chart_of_accounts_id
892: FROM fii_slg_assignments