DBA Data[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_ADDRESSES

Line 4755: FROM per_addresses addr

4751: ,addr.telephone_number_2 telephone_number_2
4752: ,addr.telephone_number_3 telephone_number_3
4753: ,addr.add_information13 House_Number
4754: ,addr.add_information14 House_Number_Addition
4755: FROM per_addresses addr
4756: WHERE addr.person_id = c_person_id
4757: AND addr.primary_flag = 'Y'
4758: AND c_effective_date BETWEEN addr.date_from AND
4759: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'))