DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 2751: FROM FND_DESCR_FLEX_COLUMN_USAGES fus,

2747:
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

Line 2776: from FND_DESCR_FLEX_COLUMN_USAGES fus,

2772: and rul.dnz_chr_id = p_dest_id
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