APPS.PER_TMPROFILE_PKG dependencies on PER_ADDRESSES

Line 44: l_address_line1 per_addresses.address_line1%type;

40:
41: function get_address (p_person_id in number
42: ,p_effective_date in date
43: ) return varchar2 as
44: l_address_line1 per_addresses.address_line1%type;
45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;

Line 45: l_address_line2 per_addresses.address_line2%type;

41: function get_address (p_person_id in number
42: ,p_effective_date in date
43: ) return varchar2 as
44: l_address_line1 per_addresses.address_line1%type;
45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;

Line 46: l_address_line3 per_addresses.address_line3%type;

42: ,p_effective_date in date
43: ) return varchar2 as
44: l_address_line1 per_addresses.address_line1%type;
45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;

Line 47: l_region_1 per_addresses.region_1%type;

43: ) return varchar2 as
44: l_address_line1 per_addresses.address_line1%type;
45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;

Line 48: l_region_2 per_addresses.region_2%type;

44: l_address_line1 per_addresses.address_line1%type;
45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;
52: l_country per_addresses.country%type;

Line 49: l_region_3 per_addresses.region_3%type;

45: l_address_line2 per_addresses.address_line2%type;
46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;
52: l_country per_addresses.country%type;
53:

Line 50: l_town_or_city per_addresses.town_or_city%type;

46: l_address_line3 per_addresses.address_line3%type;
47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;
52: l_country per_addresses.country%type;
53:
54: l_address varchar2(1000) := null;

Line 51: l_postal_code per_addresses.postal_code%type;

47: l_region_1 per_addresses.region_1%type;
48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;
52: l_country per_addresses.country%type;
53:
54: l_address varchar2(1000) := null;
55: begin

Line 52: l_country per_addresses.country%type;

48: l_region_2 per_addresses.region_2%type;
49: l_region_3 per_addresses.region_3%type;
50: l_town_or_city per_addresses.town_or_city%type;
51: l_postal_code per_addresses.postal_code%type;
52: l_country per_addresses.country%type;
53:
54: l_address varchar2(1000) := null;
55: begin
56: select address_line1,

Line 74: from per_addresses

70: l_region_3,
71: l_town_or_city,
72: l_postal_code,
73: l_country
74: from per_addresses
75: where person_id = p_person_id
76: and primary_flag = 'Y'
77: and p_effective_date
78: between date_from