DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on PER_ADDRESSES

Line 1043: from per_addresses ad,

1039: , region_1 ee_street_name
1040: , region_2 ee_suburb_district
1041: , town_or_city ee_town_city
1042: , postal_code ee_postal_code
1043: from per_addresses ad,
1044: per_all_assignments_f paf
1045: where paf.assignment_id = p_assignment_id
1046: and paf.person_id = ad.person_id
1047: and g_archive_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))