DBA Data[Home] [Help]

APPS.PAY_JP_ITAX_ARCHIVE_PKG dependencies on PER_ADDRESSES

Line 527: per_addresses adrr,

523: decode(adrr.address_id, null, adrc.town_or_city, adrr.town_or_city) district_code,
524: asg.organization_id
525: from per_all_assignments_f asg,
526: per_all_people_f per,
527: per_addresses adrr,
528: per_addresses adrc
529: where asg.assignment_id = cp_assignment_id
530: and cp_effective_date
531: between asg.effective_start_date and asg.effective_end_date

Line 528: per_addresses adrc

524: asg.organization_id
525: from per_all_assignments_f asg,
526: per_all_people_f per,
527: per_addresses adrr,
528: per_addresses adrc
529: where asg.assignment_id = cp_assignment_id
530: and cp_effective_date
531: between asg.effective_start_date and asg.effective_end_date
532: and per.person_id = asg.person_id