APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_ADDRESSES

Line 3071: l_address_line1 per_addresses.address_line1%type;

3067: l_director_indicator VARCHAR2(1);
3068: --
3069: l_start_of_emp DATE;
3070: --
3071: l_address_line1 per_addresses.address_line1%type;
3072: l_address_line2 per_addresses.address_line2%type;
3073: l_address_line3 per_addresses.address_line3%type;
3074: l_town_or_city VARCHAR2(30);
3075: l_county VARCHAR2(27);

Line 3072: l_address_line2 per_addresses.address_line2%type;

3068: --
3069: l_start_of_emp DATE;
3070: --
3071: l_address_line1 per_addresses.address_line1%type;
3072: l_address_line2 per_addresses.address_line2%type;
3073: l_address_line3 per_addresses.address_line3%type;
3074: l_town_or_city VARCHAR2(30);
3075: l_county VARCHAR2(27);
3076: l_country_name fnd_territories_tl.territory_short_name%type;

Line 3073: l_address_line3 per_addresses.address_line3%type;

3069: l_start_of_emp DATE;
3070: --
3071: l_address_line1 per_addresses.address_line1%type;
3072: l_address_line2 per_addresses.address_line2%type;
3073: l_address_line3 per_addresses.address_line3%type;
3074: l_town_or_city VARCHAR2(30);
3075: l_county VARCHAR2(27);
3076: l_country_name fnd_territories_tl.territory_short_name%type;
3077: l_country per_addresses.country%type;

Line 3077: l_country per_addresses.country%type;

3073: l_address_line3 per_addresses.address_line3%type;
3074: l_town_or_city VARCHAR2(30);
3075: l_county VARCHAR2(27);
3076: l_country_name fnd_territories_tl.territory_short_name%type;
3077: l_country per_addresses.country%type;
3078: l_postal_code VARCHAR2(8);
3079: --
3080: l_ni_tot NUMBER:= 0;
3081: l_ni_ees NUMBER:= 0;

Line 3367: FROM per_addresses pad,

3363: ltrim(rtrim(pad.town_or_city)) town_or_city,
3364: substr(l.meaning,1,27) county,
3365: substr(pad.postal_code,1,8),
3366: country
3367: FROM per_addresses pad,
3368: hr_lookups l
3369: WHERE pad.person_id = p_person_id
3370: AND pad.primary_flag = 'Y'
3371: AND l.lookup_type(+) = 'GB_COUNTY'