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.HR_US_REPORTS dependencies on PER_ADDRESSES

Line 104: per_addresses in get_address and get_employee_address

100:
101: 40.23 26-FEB-1997 hekim In get_address_3lines, take substring of city name
102: 40.24 28-Jul-1997 nlee Change pay_state_rules to pay_us_states in get_state_name.
103: Change the selection of all rows from hr_locations and
104: per_addresses in get_address and get_employee_address
105: functions to selection of the specific rows that are
106: needed to increase performance and avoid overflow problem.
107: Change the sql statement to cursor statement in get_new_hire_contact
108: and add the exception handlers to the function.

Line 170: FROM per_addresses addr,

166: RETURN VARCHAR2 IS
167:
168: CURSOR c_get_p_payee IS
169: SELECT SUBSTR(INITCAP(RTRIM(ppf.title)||' '||RTRIM(ppf.first_name)||' '||RTRIM(ppf.last_name)),1,60)
170: FROM per_addresses addr,
171: per_people_f ppf
172: WHERE ppf.person_id = IN_payee_id
173: AND ppf.business_group_id+0 = IN_business_group_id
174: AND IN_payment_date BETWEEN ppf.effective_start_date

Line 521: address_record per_addresses%rowtype;

517: f_addr_line1 varchar2(240) := NULL;
518: f_addr_line2 varchar2(240) := NULL;
519: f_city_state_zip varchar2(250) := NULL;
520: --
521: address_record per_addresses%rowtype;
522: cursor get_address_record is
523: select * from per_addresses
524: where person_id = p_person_id
525: and primary_flag='Y'

Line 523: select * from per_addresses

519: f_city_state_zip varchar2(250) := NULL;
520: --
521: address_record per_addresses%rowtype;
522: cursor get_address_record is
523: select * from per_addresses
524: where person_id = p_person_id
525: and primary_flag='Y'
526: and nvl(date_to, p_effective_date) >= p_effective_date;
527: --

Line 578: -- address_record per_addresses%rowtype;

574: --
575: f_address varchar2(340) := NULL;
576:
577: --
578: -- address_record per_addresses%rowtype;
579: --
580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;

Line 580: v_address_line1 per_addresses.address_line1%TYPE;

576:
577: --
578: -- address_record per_addresses%rowtype;
579: --
580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;

Line 581: v_address_line2 per_addresses.address_line2%TYPE;

577: --
578: -- address_record per_addresses%rowtype;
579: --
580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;
585: v_postal_code per_addresses.postal_code%TYPE;

Line 582: v_address_line3 per_addresses.address_line3%TYPE;

578: -- address_record per_addresses%rowtype;
579: --
580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;
585: v_postal_code per_addresses.postal_code%TYPE;
586: --

Line 583: v_town_or_city per_addresses.town_or_city%TYPE;

579: --
580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;
585: v_postal_code per_addresses.postal_code%TYPE;
586: --
587: cursor get_address_record is

Line 584: v_region_2 per_addresses.region_2%TYPE;

580: v_address_line1 per_addresses.address_line1%TYPE;
581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;
585: v_postal_code per_addresses.postal_code%TYPE;
586: --
587: cursor get_address_record is
588: select address_line1, address_line2, address_line3,

Line 585: v_postal_code per_addresses.postal_code%TYPE;

581: v_address_line2 per_addresses.address_line2%TYPE;
582: v_address_line3 per_addresses.address_line3%TYPE;
583: v_town_or_city per_addresses.town_or_city%TYPE;
584: v_region_2 per_addresses.region_2%TYPE;
585: v_postal_code per_addresses.postal_code%TYPE;
586: --
587: cursor get_address_record is
588: select address_line1, address_line2, address_line3,
589: town_or_city, region_2, postal_code

Line 590: from per_addresses

586: --
587: cursor get_address_record is
588: select address_line1, address_line2, address_line3,
589: town_or_city, region_2, postal_code
590: from per_addresses
591: where person_id = p_person_id
592: and primary_flag = 'Y'
593: and nvl(date_to, sysdate) >= sysdate;
594: --

Line 1777: -- address_record per_addresses%rowtype;

1773: p_address out nocopy varchar2) IS
1774: --
1775: f_address varchar2(300) := NULL;
1776: --
1777: -- address_record per_addresses%rowtype;
1778: --
1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;

Line 1779: v_address_line1 per_addresses.address_line1%TYPE;

1775: f_address varchar2(300) := NULL;
1776: --
1777: -- address_record per_addresses%rowtype;
1778: --
1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;

Line 1780: v_address_line2 per_addresses.address_line2%TYPE;

1776: --
1777: -- address_record per_addresses%rowtype;
1778: --
1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;
1784: v_postal_code per_addresses.postal_code%TYPE;

Line 1781: v_address_line3 per_addresses.address_line3%TYPE;

1777: -- address_record per_addresses%rowtype;
1778: --
1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;
1784: v_postal_code per_addresses.postal_code%TYPE;
1785: --

Line 1782: v_town_or_city per_addresses.town_or_city%TYPE;

1778: --
1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;
1784: v_postal_code per_addresses.postal_code%TYPE;
1785: --
1786: cursor get_address_record is

Line 1783: v_region_2 per_addresses.region_2%TYPE;

1779: v_address_line1 per_addresses.address_line1%TYPE;
1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;
1784: v_postal_code per_addresses.postal_code%TYPE;
1785: --
1786: cursor get_address_record is
1787: select address_line1, address_line2, address_line3,

Line 1784: v_postal_code per_addresses.postal_code%TYPE;

1780: v_address_line2 per_addresses.address_line2%TYPE;
1781: v_address_line3 per_addresses.address_line3%TYPE;
1782: v_town_or_city per_addresses.town_or_city%TYPE;
1783: v_region_2 per_addresses.region_2%TYPE;
1784: v_postal_code per_addresses.postal_code%TYPE;
1785: --
1786: cursor get_address_record is
1787: select address_line1, address_line2, address_line3,
1788: town_or_city, region_2, postal_code

Line 1789: from per_addresses

1785: --
1786: cursor get_address_record is
1787: select address_line1, address_line2, address_line3,
1788: town_or_city, region_2, postal_code
1789: from per_addresses
1790: where person_id = p_person_id
1791: and primary_flag = 'Y'
1792: and nvl(date_to, sysdate) >= sysdate;
1793: --