APPS.GCS_LEX_MAP_API_PKG dependencies on FND_FLEX_VALUE_SETS

Line 819: fnd_flex_value_sets ffvs

815: FROM gcs_lex_map_rule_sets rst,
816: gcs_lex_map_rule_stages rstg,
817: gcs_lex_map_rules r,
818: gcs_lex_map_columns mc,
819: fnd_flex_value_sets ffvs
820: WHERE rst.rule_set_id = rstg.rule_set_id
821: AND rstg.rule_stage_id = r.rule_stage_id
822: AND r.target_column_id = mc.column_id
823: AND r.value_set_id = ffvs.flex_value_set_id

Line 1613: FROM fnd_flex_value_sets ffvs

1609:
1610: -- validation type is 'I' for independent, and 'F' for table-validated.
1611: CURSOR value_set_info(val_set_id NUMBER) IS
1612: SELECT ffvs.validation_type
1613: FROM fnd_flex_value_sets ffvs
1614: WHERE ffvs.flex_value_set_id = val_set_id;
1615:
1616: vs_validation_type VARCHAR2(50);
1617:

Line 2542: FROM fnd_flex_value_sets ffvs

2538: IF validation_type_code = 'V' THEN
2539: -- validation type is 'I' for independent, and 'F' for table-validated.
2540: SELECT ffvs.validation_type
2541: INTO vs_validation_type
2542: FROM fnd_flex_value_sets ffvs
2543: WHERE ffvs.flex_value_set_id = validate_column.value_set_id;
2544:
2545: IF vs_validation_type = 'I' THEN
2546: validation_text := validation_text || 'NOT EXISTS ' ||

Line 3442: fnd_flex_value_sets ffv

3438: vs_name
3439: FROM gcs_lex_map_rules r,
3440: gcs_lex_map_columns mc,
3441: gcs_lex_map_rule_stages rstg,
3442: fnd_flex_value_sets ffv
3443: WHERE r.rule_stage_id = rstg.rule_stage_id
3444: AND r.value_set_id = ffv.flex_value_set_id
3445: AND r.target_column_id = mc.column_id
3446: AND r.rule_id = error_table(i).rule_id;