DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PER_ADDRESSES

Line 3347: from per_addresses addr

3343: ,cp_run_effective_date in date) is
3344: select nvl(ADDR.add_information19,ADDR.region_1),
3345: nvl(ADDR.add_information17,ADDR.region_2),
3346: nvl(addr.add_information18,addr.town_or_city)
3347: from per_addresses addr
3348: ,per_all_assignments_f assign
3349: where cp_run_effective_date between assign.effective_start_date
3350: and assign.effective_end_date
3351: and assign.assignment_id = cp_assignment_id

Line 6862: per_addresses addr,

6858: rtrim(addr.town_or_city),
6859: addr.region_2,
6860: addr.postal_code
6861: from
6862: per_addresses addr,
6863: per_all_people_f ppf
6864: where
6865: ppf.person_id = cp_payee_id
6866: and ppf.business_group_id = cp_business_group_id