DBA Data[Home] [Help]

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'