[Home] [Help]
1361: p_pre number) IS
1362: SELECT
1363: pei_information7
1364: FROM
1365: per_people_extra_info pei
1366: WHERE
1367: to_number(pei.person_id) = p_person_id AND
1368: pei.information_type = 'PAY_CA_RL2_FORM_NO' AND
1369: to_number(pei.pei_information6) = p_pre AND