DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 2748: FROM FND_DESCR_FLEX_COLUMN_USAGES fus,

2744:
2745: CURSOR c_rule_amt_crs(p_rule_code IN VARCHAR2, p_rule_group_code IN VARCHAR2) IS
2746: --Start modified abhsaxen for performance SQLID 20562750
2747: SELECT fus.application_column_name
2748: FROM FND_DESCR_FLEX_COLUMN_USAGES fus,
2749: fnd_flex_value_sets ffv,
2750: okc_rg_def_rules defrul,
2751: fnd_lookup_values flup,
2752: okc_rule_defs_v rulup

Line 2773: from FND_DESCR_FLEX_COLUMN_USAGES fus,

2769: and rul.dnz_chr_id = p_dest_id
2770: and rgp.id = p_rgp_id
2771: and exists (
2772: select 1
2773: from FND_DESCR_FLEX_COLUMN_USAGES fus,
2774: fnd_flex_value_sets ffv,
2775: okc_rg_def_rules defrul,
2776: fnd_lookup_values flup,
2777: okc_rule_defs_b rulup