DBA Data[Home] [Help]

APPS.PAY_SG_SOE dependencies on PER_ADDRESSES

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

81: ( p_assignment_action_id number)
82: return number;
83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,

Line 86: p_address_line1 out nocopy per_addresses.address_line1%type,

82: return number;
83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,

Line 87: p_address_line2 out nocopy per_addresses.address_line2%type,

83:
84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);

Line 88: p_address_line3 out nocopy per_addresses.address_line3%type,

84: procedure get_home_address
85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:

Line 89: p_town_city out nocopy per_addresses.town_or_city%type,

85: (p_person_id in per_addresses.person_id%type,
86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address

Line 90: p_postal_code out nocopy per_addresses.postal_code%type,

86: p_address_line1 out nocopy per_addresses.address_line1%type,
87: p_address_line2 out nocopy per_addresses.address_line2%type,
88: p_address_line3 out nocopy per_addresses.address_line3%type,
89: p_town_city out nocopy per_addresses.town_or_city%type,
90: p_postal_code out nocopy per_addresses.postal_code%type,
91: p_country_name out nocopy fnd_territories_tl.territory_short_name%type);
92:
93: procedure get_work_address
94: (p_location_id in hr_locations.location_id%type,