APPS.PAY_GB_EDI_P46_CAR dependencies on PER_ADDRESSES

Line 2937: FROM per_addresses addr

2933: substr(hr_general.decode_lookup('GB_COUNTY',
2934: addr.region_1), 1, 35) region_1,
2935: addr.country,
2936: addr.postal_code
2937: FROM per_addresses addr
2938: WHERE addr.person_id = p_person_id
2939: AND addr.primary_flag = 'Y'
2940: AND l_eff_date BETWEEN addr.date_from
2941: AND nvl(addr.date_to, fnd_date.canonical_to_date('4712/12/31'));