APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on PER_PHONES
Line 5100: from per_phones PHONE ,
5096:
5097: begin
5098: select PHONE.phone_number
5099: into l_employee_phone_no 5100: from per_phones PHONE , 5101: fnd_sessions SES
5102: where PHONE.parent_id (+) = l_person_id
5103: and PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
5104: and PHONE.phone_type (+)= 'W1'