DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on OKC_BUS_VARIABLES_V

Line 221: FROM okc_bus_variables_v a,

217: a.description, xprt_value_set_name value_set_name,
218: variable_datatype, b.longlist_flag, b.validation_type,
219: b.flex_value_set_id value_set_id, variable_type,
220: vartype.meaning var_type_meaning
221: FROM okc_bus_variables_v a,
222: fnd_flex_value_sets b,
223: fnd_lookups vartype
224: WHERE contract_expert_yn = 'Y'
225: AND variable_datatype <> 'D'

Line 235: FROM okc_bus_variables_v a,

231: a.description, flex_value_set_name value_set_name,
232: variable_datatype, b.longlist_flag, b.validation_type,
233: b.flex_value_set_id value_set_id, variable_type,
234: vartype.meaning var_type_meaning
235: FROM okc_bus_variables_v a,
236: fnd_flex_value_sets b,
237: fnd_lookups vartype
238: WHERE a.variable_type = 'U'
239: AND a.value_set_id = b.flex_value_set_id

Line 415: FROM okc_bus_variables_v

411: IS
412: CURSOR cur_validate_variable
413: IS
414: SELECT 'Y'
415: FROM okc_bus_variables_v
416: WHERE contract_expert_yn = 'Y'
417: AND variable_datatype = 'N'
418: AND variable_intent = p_intent
419: AND variable_code = p_variable_code;