DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on FND_FLEX_VALUE_SETS

Line 2752: fnd_flex_value_sets ffv,

2748: CURSOR c_rule_amt_crs(p_rule_code IN VARCHAR2, p_rule_group_code IN VARCHAR2) IS
2749: --Start modified abhsaxen for performance SQLID 20562750
2750: SELECT fus.application_column_name
2751: FROM FND_DESCR_FLEX_COLUMN_USAGES fus,
2752: fnd_flex_value_sets ffv,
2753: okc_rg_def_rules defrul,
2754: fnd_lookup_values flup,
2755: okc_rule_defs_v rulup
2756: WHERE fus.DESCRIPTIVE_FLEX_CONTEXT_CODE = defrul.rdf_code

Line 2777: fnd_flex_value_sets ffv,

2773: and rgp.id = p_rgp_id
2774: and exists (
2775: select 1
2776: from FND_DESCR_FLEX_COLUMN_USAGES fus,
2777: fnd_flex_value_sets ffv,
2778: okc_rg_def_rules defrul,
2779: fnd_lookup_values flup,
2780: okc_rule_defs_b rulup
2781: where fus.descriptive_flex_context_code = defrul.rdf_code