APPS.XLA_AAD_UPLOAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 433: LEFT OUTER JOIN fnd_flex_value_sets val

429:
430: CURSOR c_invalid_value_set IS
431: SELECT xal.flex_value_set_name
432: FROM xla_aad_loader_defns_t xal
433: LEFT OUTER JOIN fnd_flex_value_sets val
434: ON val.flex_value_set_name = xal.flex_value_set_name
435: WHERE xal.staging_amb_context_code = p_staging_context_code
436: AND xal.flex_value_set_name IS NOT NULL
437: AND val.flex_value_set_id IS NULL;

Line 1192: ,fnd_flex_value_sets val

1188: ,0
1189: FROM xla_aad_loader_defns_t xal
1190: ,fnd_application fap
1191: ,fnd_id_flex_structures flex
1192: ,fnd_flex_value_sets val
1193: WHERE fap.application_short_name(+) = xal.view_app_short_name
1194: AND val.flex_value_set_name(+) = xal.flex_value_set_name
1195: AND flex.id_flex_code = 'GL#'
1196: AND flex.application_id = 101

Line 1821: ,fnd_flex_value_sets val

1817: ,0
1818: FROM xla_aad_loader_defns_t xal
1819: ,fnd_id_flex_structures fift
1820: ,fnd_id_flex_structures fifa
1821: ,fnd_flex_value_sets val
1822: WHERE fift.application_id(+) = 101
1823: AND fift.id_flex_code(+) = 'GL#'
1824: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
1825: AND fifa.application_id(+) = 101