DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on PER_ADDRESSES

Line 3451: l_forwarding_address_line1 per_addresses.address_line1%type;

3447: l_service_comp_date VARCHAR2(150);
3448: l_education_level VARCHAR2(60);
3449: l_year_degree_attained VARCHAR2(60);
3450: l_academic_discipline VARCHAR2(60);
3451: l_forwarding_address_line1 per_addresses.address_line1%type;
3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;

Line 3452: l_forwarding_address_line2 per_addresses.address_line2%type;

3448: l_education_level VARCHAR2(60);
3449: l_year_degree_attained VARCHAR2(60);
3450: l_academic_discipline VARCHAR2(60);
3451: l_forwarding_address_line1 per_addresses.address_line1%type;
3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;

Line 3453: l_forwarding_address_line3 per_addresses.address_line3%type;

3449: l_year_degree_attained VARCHAR2(60);
3450: l_academic_discipline VARCHAR2(60);
3451: l_forwarding_address_line1 per_addresses.address_line1%type;
3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;
3457: l_forwarding_country per_addresses.country%type;

Line 3454: l_forwarding_town_or_city per_addresses.town_or_city%type;

3450: l_academic_discipline VARCHAR2(60);
3451: l_forwarding_address_line1 per_addresses.address_line1%type;
3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;
3457: l_forwarding_country per_addresses.country%type;
3458: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;

Line 3455: l_forwarding_region_2 per_addresses.region_2%type;

3451: l_forwarding_address_line1 per_addresses.address_line1%type;
3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;
3457: l_forwarding_country per_addresses.country%type;
3458: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3459:

Line 3456: l_forwarding_postal_code per_addresses.postal_code%type;

3452: l_forwarding_address_line2 per_addresses.address_line2%type;
3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;
3457: l_forwarding_country per_addresses.country%type;
3458: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3459:
3460: l_tenure VARCHAR2(150);

Line 3457: l_forwarding_country per_addresses.country%type;

3453: l_forwarding_address_line3 per_addresses.address_line3%type;
3454: l_forwarding_town_or_city per_addresses.town_or_city%type;
3455: l_forwarding_region_2 per_addresses.region_2%type;
3456: l_forwarding_postal_code per_addresses.postal_code%type;
3457: l_forwarding_country per_addresses.country%type;
3458: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3459:
3460: l_tenure VARCHAR2(150);
3461: l_annuitant_indicator VARCHAR2(150);