eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SG_SOE dependencies on PER_ADDRESSES

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

910: ------------------------------------------------------------------------
911: -- Selects the Home Address for the Person.
912: ------------------------------------------------------------------------
913: procedure get_home_address
914: (p_person_id in per_addresses.person_id%type,
915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,

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

911: -- Selects the Home Address for the Person.
912: ------------------------------------------------------------------------
913: procedure get_home_address
914: (p_person_id in per_addresses.person_id%type,
915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,

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

912: ------------------------------------------------------------------------
913: procedure get_home_address
914: (p_person_id in per_addresses.person_id%type,
915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is

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

913: procedure get_home_address
914: (p_person_id in per_addresses.person_id%type,
915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
921:

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

914: (p_person_id in per_addresses.person_id%type,
915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
921:
922: cursor home_address

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

915: p_address_line1 out nocopy per_addresses.address_line1%type,
916: p_address_line2 out nocopy per_addresses.address_line2%type,
917: p_address_line3 out nocopy per_addresses.address_line3%type,
918: p_town_city out nocopy per_addresses.town_or_city%type,
919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
921:
922: cursor home_address
923: (c_person_id per_addresses.person_id%type) is

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

919: p_postal_code out nocopy per_addresses.postal_code%type,
920: p_country_name out nocopy fnd_territories_tl.territory_short_name%type) is
921:
922: cursor home_address
923: (c_person_id per_addresses.person_id%type) is
924: select pad.address_line1,
925: pad.address_line2,
926: pad.address_line3,
927: pad.town_or_city,

Line 930: from per_addresses pad,

926: pad.address_line3,
927: pad.town_or_city,
928: pad.postal_code,
929: ftt.territory_short_name
930: from per_addresses pad,
931: fnd_territories_tl ftt
932: where pad.person_id = c_person_id
933: and ftt.language = userenv('LANG')
934: and ftt.territory_code = pad.country