DBA Data[Home] [Help]

APPS.GHR_PROCESS_SF52 dependencies on PER_ADDRESSES

Line 3579: l_forwarding_address_line1 per_addresses.address_line1%type;

3575: l_service_comp_date VARCHAR2(150);
3576: l_education_level VARCHAR2(60);
3577: l_year_degree_attained VARCHAR2(60);
3578: l_academic_discipline VARCHAR2(60);
3579: l_forwarding_address_line1 per_addresses.address_line1%type;
3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;

Line 3580: l_forwarding_address_line2 per_addresses.address_line2%type;

3576: l_education_level VARCHAR2(60);
3577: l_year_degree_attained VARCHAR2(60);
3578: l_academic_discipline VARCHAR2(60);
3579: l_forwarding_address_line1 per_addresses.address_line1%type;
3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;

Line 3581: l_forwarding_address_line3 per_addresses.address_line3%type;

3577: l_year_degree_attained VARCHAR2(60);
3578: l_academic_discipline VARCHAR2(60);
3579: l_forwarding_address_line1 per_addresses.address_line1%type;
3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;
3585: l_forwarding_country per_addresses.country%type;

Line 3582: l_forwarding_town_or_city per_addresses.town_or_city%type;

3578: l_academic_discipline VARCHAR2(60);
3579: l_forwarding_address_line1 per_addresses.address_line1%type;
3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;
3585: l_forwarding_country per_addresses.country%type;
3586: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;

Line 3583: l_forwarding_region_2 per_addresses.region_2%type;

3579: l_forwarding_address_line1 per_addresses.address_line1%type;
3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;
3585: l_forwarding_country per_addresses.country%type;
3586: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3587:

Line 3584: l_forwarding_postal_code per_addresses.postal_code%type;

3580: l_forwarding_address_line2 per_addresses.address_line2%type;
3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;
3585: l_forwarding_country per_addresses.country%type;
3586: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3587:
3588: l_tenure VARCHAR2(150);

Line 3585: l_forwarding_country per_addresses.country%type;

3581: l_forwarding_address_line3 per_addresses.address_line3%type;
3582: l_forwarding_town_or_city per_addresses.town_or_city%type;
3583: l_forwarding_region_2 per_addresses.region_2%type;
3584: l_forwarding_postal_code per_addresses.postal_code%type;
3585: l_forwarding_country per_addresses.country%type;
3586: l_forwarding_country_short_na fnd_territories_tl.territory_short_name%type;
3587:
3588: l_tenure VARCHAR2(150);
3589: l_annuitant_indicator VARCHAR2(150);