52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
55: description, global_flag, enabled_flag
56: FROM fnd_descr_flex_contexts_vl
57: WHERE application_id = flexfield.application_id
58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:
58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
69: WHERE application_id = flexfield.application_id
70: AND descriptive_flexfield_name = flexfield.flexfield_name
71: ORDER BY creation_date;
72:
72:
73: CURSOR context_c_new IS
74: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
75: description, global_flag, enabled_flag
76: FROM fnd_descr_flex_contexts_vl
77: WHERE application_id = flexfield.application_id
78: AND descriptive_flexfield_name = flexfield.flexfield_name
79: ORDER BY creation_date, descriptive_flex_context_code ;
80: