APPS.PAY_SA_GOSI_REPORTS dependencies on PER_ADDRESSES

Line 2744: FROM per_addresses pa

2740: pa.region_1 R1,
2741: pa.region_2 R2,
2742: pa.region_3 R3,
2743: pa.postal_code ZIP
2744: FROM per_addresses pa
2745: WHERE pa.primary_flag = 'Y'
2746: AND pa.person_id = l_person_id
2747: AND l_effective_date BETWEEN trunc(pa.date_from,'MM')
2748: AND nvl(pa.date_to,to_date('31-12-4712','DD-MM-YYYY'));