APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_ADDRESSES

Line 3186: l_address_line1 per_addresses.address_line1%type;

3182: l_director_indicator VARCHAR2(1);
3183: --
3184: l_start_of_emp DATE;
3185: --
3186: l_address_line1 per_addresses.address_line1%type;
3187: l_address_line2 per_addresses.address_line2%type;
3188: l_address_line3 per_addresses.address_line3%type;
3189: l_town_or_city VARCHAR2(30);
3190: l_county VARCHAR2(27);

Line 3187: l_address_line2 per_addresses.address_line2%type;

3183: --
3184: l_start_of_emp DATE;
3185: --
3186: l_address_line1 per_addresses.address_line1%type;
3187: l_address_line2 per_addresses.address_line2%type;
3188: l_address_line3 per_addresses.address_line3%type;
3189: l_town_or_city VARCHAR2(30);
3190: l_county VARCHAR2(27);
3191: l_country_name fnd_territories_tl.territory_short_name%type;

Line 3188: l_address_line3 per_addresses.address_line3%type;

3184: l_start_of_emp DATE;
3185: --
3186: l_address_line1 per_addresses.address_line1%type;
3187: l_address_line2 per_addresses.address_line2%type;
3188: l_address_line3 per_addresses.address_line3%type;
3189: l_town_or_city VARCHAR2(30);
3190: l_county VARCHAR2(27);
3191: l_country_name fnd_territories_tl.territory_short_name%type;
3192: l_country per_addresses.country%type;

Line 3192: l_country per_addresses.country%type;

3188: l_address_line3 per_addresses.address_line3%type;
3189: l_town_or_city VARCHAR2(30);
3190: l_county VARCHAR2(27);
3191: l_country_name fnd_territories_tl.territory_short_name%type;
3192: l_country per_addresses.country%type;
3193: l_postal_code VARCHAR2(8);
3194: --
3195: l_ni_tot NUMBER:= 0;
3196: l_ni_ees NUMBER:= 0;

Line 3496: FROM per_addresses pad,

3492: ltrim(rtrim(pad.town_or_city)) town_or_city,
3493: substr(l.meaning,1,27) county,
3494: substr(pad.postal_code,1,8),
3495: country
3496: FROM per_addresses pad,
3497: hr_lookups l
3498: WHERE pad.person_id = p_person_id
3499: AND pad.primary_flag = 'Y'
3500: AND l.lookup_type(+) = 'GB_COUNTY'