DBA Data[Home] [Help]

APPS.OKC_CONDITION_EVAL_PVT dependencies on OKC_CONDITION_OCCURS

Line 75: ,okc_condition_occurs coe

71: CURSOR aav_cur(X IN NUMBER)
72: IS
73: SELECT aav.value
74: FROM okc_action_att_vals aav
75: ,okc_condition_occurs coe
76: WHERE coe.id = aav.coe_id
77: AND coe.cnh_id = p_cnh_id
78: AND aav.aae_id = X
79: ORDER BY coe.datetime desc;

Line 639: FROM okc_condition_occurs coe

635: RETURN BOOLEAN IS
636:
637: CURSOR coe_cur IS
638: SELECT 'X'
639: FROM okc_condition_occurs coe
640: WHERE coe.cnh_id = p_cnh_id;
641: coe_rec coe_cur%ROWTYPE;
642:
643: