[Home] [Help]
9702: p_to IN OUT NOCOPY tgdv_ext_rec_type
9703: ) IS
9704: CURSOR c_start_end(p_id IN NUMBER) IS
9705: SELECT start_date,end_date
9706: FROM okc_time_ia_startend_val_v
9707: WHERE id = p_id;
9708: BEGIN
9709: p_to.id := p_from.id;
9710: p_to.tve_id_limited := p_from.tve_id_limited;
9878: ) IS
9879:
9880: CURSOR c_start_end(p_id IN NUMBER) IS
9881: SELECT start_date,end_date
9882: FROM okc_time_ia_startend_val_v
9883: WHERE id = p_id;
9884:
9885: CURSOR c_cyl(p_id IN NUMBER) IS
9886: SELECT uom_code,duration,active_yn
10062: ATTRIBUTE12,
10063: ATTRIBUTE13,
10064: ATTRIBUTE14,
10065: ATTRIBUTE15
10066: FROM OKC_TIME_IA_STARTEND_VAL_V
10067: WHERE ID = p_id;
10068:
10069: BEGIN
10070: l_return_status := get_tvev_rec( p_tve_id => p_tve_id,