842: WHERE id = p_id;
843:
844: CURSOR c_ctcv IS
845: SELECT id 846: FROM okc_contacts 847: WHERE cpl_id = p_cpl_id;
848:
849: BEGIN
850: x_return_status := l_return_status;
Line 3080: FROM OKC_CONTACTS_V
3076: ATTRIBUTE12,
3077: ATTRIBUTE13,
3078: ATTRIBUTE14,
3079: ATTRIBUTE15 3080: FROM OKC_CONTACTS_V 3081: WHERE ID = p_ctc_id;
3082: BEGIN
3083: OPEN c_ctcv_rec;
3084: FETCH c_ctcv_rec