APPS.XLA_AAD_UPLOAD_PVT dependencies on FND_FLEX_VALUE_SETS

Line 443: LEFT OUTER JOIN fnd_flex_value_sets val

439:
440: CURSOR c_invalid_value_set IS
441: SELECT xal.flex_value_set_name
442: FROM xla_aad_loader_defns_t xal
443: LEFT OUTER JOIN fnd_flex_value_sets val
444: ON val.flex_value_set_name = xal.flex_value_set_name
445: WHERE xal.staging_amb_context_code = p_staging_context_code
446: AND xal.flex_value_set_name IS NOT NULL
447: AND val.flex_value_set_id IS NULL;

Line 1389: ,fnd_flex_value_sets val

1385: ,0
1386: FROM xla_aad_loader_defns_t xal
1387: ,fnd_application fap
1388: ,fnd_id_flex_structures flex
1389: ,fnd_flex_value_sets val
1390: ,fnd_flex_value_sets oval -- Added for ER 9395160
1391: WHERE fap.application_short_name(+) = xal.view_app_short_name
1392: AND val.flex_value_set_name(+) = xal.flex_value_set_name
1393: and oval.flex_value_set_name(+) = xal.output_flex_value_set_name -- Added for ER 9395160

Line 1390: ,fnd_flex_value_sets oval -- Added for ER 9395160

1386: FROM xla_aad_loader_defns_t xal
1387: ,fnd_application fap
1388: ,fnd_id_flex_structures flex
1389: ,fnd_flex_value_sets val
1390: ,fnd_flex_value_sets oval -- Added for ER 9395160
1391: WHERE fap.application_short_name(+) = xal.view_app_short_name
1392: AND val.flex_value_set_name(+) = xal.flex_value_set_name
1393: and oval.flex_value_set_name(+) = xal.output_flex_value_set_name -- Added for ER 9395160
1394: AND flex.id_flex_code = 'GL#'

Line 2150: ,fnd_flex_value_sets val

2146: ,0
2147: FROM xla_aad_loader_defns_t xal
2148: ,fnd_id_flex_structures fift
2149: ,fnd_id_flex_structures fifa
2150: ,fnd_flex_value_sets val
2151: WHERE fift.application_id(+) = 101
2152: AND fift.id_flex_code(+) = 'GL#'
2153: AND fift.id_flex_structure_code(+) = trans_coa_id_flex_struct_code
2154: AND fifa.application_id(+) = 101