Line 33: and add_months(p_effective_date,-48) < ghr_general.return_rif_date(pea.segment3)
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 33: and add_months(p_effective_date,-48) < ghr_general.return_rif_date(pea.segment3) 34: order by 3 desc ;
35:
36:
37: begin