APPS.OKC_QUERY dependencies on OKC_ACTION_ATT_VALS

Line 572: l_aae_value OKC_ACTION_ATT_VALS_V.VALUE%TYPE;

568: l_source_doc_number_yn VARCHAR2(200);
569: l_acn_id OKC_ACTIONS_V.ID%TYPE;
570: l_cnh_id OKC_CONDITION_HEADERS_V.ID%TYPE;
571: l_aae_id OKC_ACTION_ATTRIBUTES_V.ID%TYPE;
572: l_aae_value OKC_ACTION_ATT_VALS_V.VALUE%TYPE;
573:
574: CURSOR c_cnh_id IS
575: SELECT cnh_id
576: FROM okc_condition_occurs

Line 592: FROM okc_action_att_vals

588: AND source_doc_number_yn = 'Y';
589:
590: CURSOR c_aae_value IS
591: SELECT value
592: FROM okc_action_att_vals
593: WHERE aae_id = l_aae_id
594: AND coe_id = p_coe_id;
595:
596: BEGIN