DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 518: per_addresses adrr,

514: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
515: asg.organization_id
516: from per_all_assignments_f asg,
517: per_all_people_f per,
518: per_addresses adrr,
519: per_addresses adrc
520: where asg.assignment_id = cp_assignment_id
521: and cp_effective_date
522: between asg.effective_start_date and asg.effective_end_date

Line 519: per_addresses adrc

515: asg.organization_id
516: from per_all_assignments_f asg,
517: per_all_people_f per,
518: per_addresses adrr,
519: per_addresses adrc
520: where asg.assignment_id = cp_assignment_id
521: and cp_effective_date
522: between asg.effective_start_date and asg.effective_end_date
523: and per.person_id = asg.person_id