DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_ADDRESSES

Line 7783: FROM per_addresses addr

7779: ,addr.telephone_number_2 telephone_number_2
7780: ,addr.telephone_number_3 telephone_number_3
7781: ,addr.add_information13 House_Number
7782: ,addr.add_information14 House_Number_Addition
7783: FROM per_addresses addr
7784: WHERE addr.person_id = c_person_id
7785: AND addr.primary_flag = 'Y'
7786: AND c_effective_date BETWEEN addr.date_from AND
7787: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'))