1002: INTO l_ma_resides_true
1003: FROM dual
1004: WHERE EXISTS (
1005: SELECT '1'
1006: FROM per_assignments_f paf,
1007: per_addresses pad
1008: WHERE paf.assignment_id = l_ass_id
1009: AND paf.person_id = pad.person_id
1010: AND pad.date_from <= l_effective_date