APPS.PAY_AU_SOE_PKG dependencies on PER_ADDRESSES

Line 19: (p_person_id in per_addresses.person_id%type,

15: ------------------------------------------------------------------------
16: -- Selects the Home Address for the Person.
17: ------------------------------------------------------------------------
18: procedure get_home_address
19: (p_person_id in per_addresses.person_id%type,
20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,

Line 20: p_address_line1 out NOCOPY per_addresses.address_line1%type,

16: -- Selects the Home Address for the Person.
17: ------------------------------------------------------------------------
18: procedure get_home_address
19: (p_person_id in per_addresses.person_id%type,
20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,

Line 21: p_address_line2 out NOCOPY per_addresses.address_line2%type,

17: ------------------------------------------------------------------------
18: procedure get_home_address
19: (p_person_id in per_addresses.person_id%type,
20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is

Line 22: p_address_line3 out NOCOPY per_addresses.address_line3%type,

18: procedure get_home_address
19: (p_person_id in per_addresses.person_id%type,
20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
26:

Line 23: p_town_city out NOCOPY per_addresses.town_or_city%type,

19: (p_person_id in per_addresses.person_id%type,
20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
26:
27: cursor home_address

Line 24: p_postal_code out NOCOPY per_addresses.postal_code%type,

20: p_address_line1 out NOCOPY per_addresses.address_line1%type,
21: p_address_line2 out NOCOPY per_addresses.address_line2%type,
22: p_address_line3 out NOCOPY per_addresses.address_line3%type,
23: p_town_city out NOCOPY per_addresses.town_or_city%type,
24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
26:
27: cursor home_address
28: (c_person_id per_addresses.person_id%type) is

Line 28: (c_person_id per_addresses.person_id%type) is

24: p_postal_code out NOCOPY per_addresses.postal_code%type,
25: p_country_name out NOCOPY fnd_territories_tl.territory_short_name%type) is
26:
27: cursor home_address
28: (c_person_id per_addresses.person_id%type) is
29: select pad.address_line1,
30: pad.address_line2,
31: pad.address_line3,
32: pad.town_or_city,

Line 35: from per_addresses pad,

31: pad.address_line3,
32: pad.town_or_city,
33: pad.postal_code,
34: ftt.territory_short_name
35: from per_addresses pad,
36: fnd_territories_tl ftt
37: where pad.person_id = c_person_id
38: and ftt.language = userenv('LANG')
39: and ftt.territory_code = pad.country