APPS.OKL_RULE_APIS_PVT dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 603: -- from fnd_descr_flex_col_usage_vl dflex

599:
600: Cursor rule_dff_cur is
601: -- select dflex.descriptive_flex_context_code
602: -- , dflex.flex_value_set_id
603: -- from fnd_descr_flex_col_usage_vl dflex
604: -- where dflex.application_id=510
605: -- and dflex.descriptive_flexfield_name='OKC Rule Developer DF'
606: -- and dflex.descriptive_flex_context_code = p_rdf_code
607: -- and dflex.application_column_name = p_appl_col_name

Line 612: from fnd_descr_flex_col_usage_vl dflex,

608: --code added for rule striping (remove top union when finalized)
609: --union
610: select dflex.descriptive_flex_context_code
611: , dflex.flex_value_set_id
612: from fnd_descr_flex_col_usage_vl dflex,
613: okc_rule_defs_v rdefv
614: where dflex.application_id = rdefv.application_id
615: and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
616: and dflex.descriptive_flex_context_code = rdefv.rule_code

Line 1662: -- from fnd_descr_flex_col_usage_vl dflex

1658:
1659: Cursor rule_dff_app_col_cur is
1660: -- select dflex.descriptive_flex_context_code
1661: -- , dflex.application_column_name
1662: -- from fnd_descr_flex_col_usage_vl dflex
1663: -- where dflex.application_id=510
1664: -- and dflex.descriptive_flexfield_name='OKC Rule Developer DF'
1665: -- and dflex.descriptive_flex_context_code = p_rdf_code
1666: -- and dflex.form_left_prompt = p_rdf_name

Line 1671: from fnd_descr_flex_col_usage_vl dflex,

1667: --union
1668: --added for rule striping (once finalized remove the top portion of union)
1669: Select dflex.descriptive_flex_context_code
1670: , dflex.application_column_name
1671: from fnd_descr_flex_col_usage_vl dflex,
1672: okc_rule_defs_v rdefv
1673: where dflex.application_id = rdefv.application_id
1674: and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
1675: and dflex.descriptive_flex_context_code = rdefv.rule_code