[Home] [Help]
24: Cursor cur_sit is
25: select pea.segment2 segment2,
26: pea.segment3 segment3,
27: pan.date_from date_from
28: from per_analysis_criteria pea,
29: per_person_analyses pan
30: where pan.person_id = p_person_id
31: and decode(pan.id_flex_num,l_id_flex_num,1,2) = 1
32: and pea.analysis_criteria_id = pan.analysis_criteria_id