APPS.OKC_XPRT_XRULE_VALUES_PVT dependencies on OKC_XPRT_RULE_COND_VALS

Line 574: FROM okc_xprt_rule_cond_vals v,

570:
571: CURSOR csr_constants (p_intent VARCHAR2) IS
572: SELECT 'CONSTANT$' || v.object_value_code constant_id, --
573: q.default_value
574: FROM okc_xprt_rule_cond_vals v,
575: okc_xprt_rule_conditions c,
576: okc_xprt_rule_hdrs_all r,
577: okc_xprt_questions_b q
578: WHERE v.rule_condition_id = c.rule_condition_id

Line 1023: FROM okc_xprt_rule_cond_vals val

1019:
1020: --Bug# 9595800
1021: CURSOR c_get_old_item(p_variable_value_id VARCHAR2) IS
1022: SELECT DISTINCT OBJECT_VALUE_CODE
1023: FROM okc_xprt_rule_cond_vals val
1024: WHERE InStr(OBJECT_VALUE_CODE,p_variable_value_id||'_',1,1) = 1
1025: AND OBJECT_VALUE_CODE <> p_variable_value_id
1026: AND RULE_CONDITION_ID IN (SELECT rule_condition_id
1027: FROM OKC_XPRT_RULE_CONDITIONS