APPS.FII_SETUP_VAL_C dependencies on FND_FLEX_VALUE_SETS

Line 26: fnd_flex_value_sets fvs,

22: where slg.usage_code = 'DBI'
23: and slg.source_ledger_group_id = sas.source_ledger_group_id
24: ) coa_list,
25: fii_dim_mapping_rules dmr,
26: fnd_flex_value_sets fvs,
27: fnd_id_flex_structures_v ifs
28: where coa_list.chart_of_accounts_id = dmr.chart_of_accounts_id
29: and dmr.dimension_short_name = p_dim_short_name
30: and not exists (

Line 685: fnd_flex_value_sets e

681: where not exists (select fcm.child_fin_cat_id
682: from fii_fin_cat_mappings fcm
683: where fcm.child_fin_cat_id = v.fin_category_id )) c,
684: fnd_flex_values d,
685: fnd_flex_value_sets e
686: WHERE a.application_id = 101
687: AND a.id_flex_code = 'GL#'
688: AND a.id_flex_num = c.chart_of_accounts_id
689: AND a.segment_attribute_type = 'GL_ACCOUNT'

Line 703: fnd_flex_value_sets fvs,

699: CURSOR unmapped_udd1_cur IS
700: SELECT fvs.flex_value_set_id, fvs.flex_value_set_name,
701: fv.flex_value_id, fv.flex_value
702: FROM fnd_flex_values fv,
703: fnd_flex_value_sets fvs,
704: ( SELECT DISTINCT user_dim1_id flex_value_id
705: FROM fii_gl_ccid_dimensions
706: MINUS
707: SELECT child_value_id flex_value_id

Line 717: fnd_flex_value_sets fvs,

713: CURSOR unmapped_udd2_cur IS
714: SELECT fvs.flex_value_set_id, fvs.flex_value_set_name,
715: fv.flex_value_id, fv.flex_value
716: FROM fnd_flex_values fv,
717: fnd_flex_value_sets fvs,
718: ( SELECT distinct user_dim2_id flex_value_id
719: From fii_gl_ccid_dimensions
720: MINUS
721: SELECT child_value_id flex_value_id

Line 769: fnd_flex_value_sets e

765: WHERE NOT EXISTS (select fct.fin_category_id
766: from fii_fin_cat_type_assgns fct
767: where fct.fin_category_id = v.fin_category_id))c,
768: fnd_flex_values d,
769: fnd_flex_value_sets e
770: WHERE a.application_id = 101
771: AND a.id_flex_code = 'GL#'
772: AND a.id_flex_num = c.chart_of_accounts_id
773: AND a.segment_attribute_type = 'GL_ACCOUNT'