DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PER_ADDRESSES

Line 2775: from per_addresses addr

2771: ,cp_run_effective_date in date) is
2772: select nvl(ADDR.add_information19,ADDR.region_1),
2773: nvl(ADDR.add_information17,ADDR.region_2),
2774: nvl(addr.add_information18,addr.town_or_city)
2775: from per_addresses addr
2776: ,per_all_assignments_f assign
2777: where cp_run_effective_date between assign.effective_start_date
2778: and assign.effective_end_date
2779: and assign.assignment_id = cp_assignment_id