APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PER_PHONES

Line 3487: from per_phones PHONE ,

3483:
3484: begin
3485: select PHONE.phone_number
3486: into l_employee_phone_no
3487: from per_phones PHONE ,
3488: fnd_sessions SES
3489: where PHONE.parent_id (+) = l_person_id
3490: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
3491: and PHONE.phone_type (+)= 'W1'