APPS.FII_FDHM_PKG dependencies on FII_SLG_ASSIGNMENTS

Line 390: FROM fii_slg_assignments

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
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

Line 460: FROM fii_slg_assignments

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
460: FROM fii_slg_assignments
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

Line 508: FROM fii_slg_assignments

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
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

Line 587: FROM fii_slg_assignments

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
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

Line 610: FROM fii_slg_assignments

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
613: AND r.chart_of_accounts_id = s.chart_of_accounts_id
614: union

Line 640: FROM fii_slg_assignments

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
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

Line 892: FROM fii_slg_assignments

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
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