[Home] [Help]
APPS.PAY_CA_ARCHIVE dependencies on PER_ADDRESSES
Line 1874: per_addresses addr
1870: addr.country country,
1871: addr.postal_code postal_code,
1872: addr.telephone_number_1 telephone_number
1873: from per_all_assignments_f assign,
1874: per_addresses addr
1875: where assign.assignment_id = l_assignment_id
1876: and l_effective_date BETWEEN
1877: assign.effective_start_date
1878: AND assign.effective_end_date