APPS.PAY_GB_EDI_P46_CAR dependencies on PER_ADDRESSES

Line 1494: FROM per_addresses addr

1490: substr(hr_general.decode_lookup('GB_COUNTY',
1491: addr.region_1), 1, 35) region_1,
1492: addr.country,
1493: addr.postal_code
1494: FROM per_addresses addr
1495: WHERE addr.person_id = p_person_id
1496: AND addr.primary_flag = 'Y'
1497: AND l_eff_date BETWEEN addr.date_from
1498: AND nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31'));