APPS.OKL_RULE_EXTRACT_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 394: fnd_descr_flex_col_usage_vl dfcu,

390: dfcu.descriptive_flexfield_name,
391: -- Bug 5876083 - udhenuko Added
392: dfcon.enabled_flag
393: From okc_rule_defs_v rdfv,
394: fnd_descr_flex_col_usage_vl dfcu,
395: fnd_descr_flex_contexts_vl dfcon
396: where dfcu.application_id = rdfv.application_id
397: and dfcu.descriptive_flex_context_code = rdfv.rule_code
398: and dfcu.descriptive_flexfield_name = rdfv.DESCRIPTIVE_FLEXFIELD_NAME

Line 598: p_segment IN FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE,

594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: p_chr_id IN NUMBER,
598: p_segment IN FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE,
599: p_longlist_flag IN VARCHAR2,
600: p_ruleinfo_column IN varchar2,
601: p_name_column IN varchar2,
602: p_id1 IN VARCHAR2,

Line 1120: fnd_descr_flex_col_usage_vl dfcu

1116: /*select dfcu.descriptive_flex_context_code
1117: , dfcu.application_column_name
1118: , dfcu.column_seq_num
1119: from fnd_lookups fl,
1120: fnd_descr_flex_col_usage_vl dfcu
1121: where fl.lookup_type = 'OKC_RULE_DEF'
1122: and fl.lookup_code = dfcu.descriptive_flex_context_code
1123: and fl.enabled_flag = 'Y'
1124: and nvl(fl.start_date_active,sysdate) <= sysdate

Line 1136: fnd_descr_flex_col_usage_vl dfcu

1132: select dfcu.descriptive_flex_context_code
1133: , dfcu.application_column_name
1134: , dfcu.column_seq_num
1135: from okc_rule_defs_v rdfv,
1136: fnd_descr_flex_col_usage_vl dfcu
1137: where dfcu.application_id = rdfv.application_id
1138: and dfcu.descriptive_flex_context_code = rdfv.rule_code
1139: and dfcu.descriptive_flexfield_name = rdfv.DESCRIPTIVE_FLEXFIELD_NAME
1140: and rdfv.rule_code = p_rgs_code