APPS.OKC_XPRT_IMPORT_RULES_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 102: FROM okc_xprt_rule_cond_vals v

98: WHERE c.rule_id = p_rule_id;
99:
100: /*CURSOR csr_rule_cond_vals(p_rule_condition_id IN NUMBER) IS
101: SELECT v.object_value_code
102: FROM okc_xprt_rule_cond_vals v
103: WHERE v.rule_condition_id = p_rule_condition_id;*/
104:
105: CURSOR csr_rule_cond_vals(p_rule_condition_id IN NUMBER) IS
106: SELECT DECODE(c.object_value_type,

Line 111: FROM okc_xprt_rule_cond_vals v, okc_xprt_rule_conditions c

107: 'VARIABLE',DECODE(SUBSTR(v.object_value_code,1,3),'OKC',v.object_value_code,'USER$' || v.object_value_code),
108: 'CONSTANT','CONSTANT$' || v.object_value_code,
109: v.object_value_code) object_value_code
110: --v.object_value_code
111: FROM okc_xprt_rule_cond_vals v, okc_xprt_rule_conditions c
112: WHERE v.rule_condition_id = c.rule_condition_id
113: AND v.rule_condition_id = p_rule_condition_id;
114:
115: CURSOR csr_rule_outcomes IS

Line 134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;

130: l_object_code_datatype okc_xprt_rule_conditions.object_code_datatype%TYPE;
131: l_operator okc_xprt_rule_conditions.operator%TYPE;
132: l_object_value_type okc_xprt_rule_conditions.object_value_type%TYPE;
133:
134: l_object_value_code okc_xprt_rule_cond_vals.object_value_code%TYPE;
135:
136: l_object_type_outcome okc_xprt_rule_outcomes.object_type%TYPE;
137: l_object_value_id okc_xprt_rule_outcomes.object_value_id%TYPE;
138: