APPS.PAY_ZA_EOY_VAL dependencies on PER_PHONES

Line 2374: from per_phones

2370: cursor csr_phones (p_phone_type varchar2) is
2371: select translate(upper(phone_number),
2372: '0123456789+-. ',
2373: '0123456789') -- remove any character other than digits
2374: from per_phones
2375: where parent_table = 'PER_ALL_PEOPLE_F'
2376: and parent_id = p_person_id
2377: and phone_type = p_phone_type
2378: and p_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY')) ;