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.

[Home] [Help]

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 162: FROM per_addresses addr,

158: RETURN VARCHAR2 IS
159:
160: CURSOR c_get_p_payee IS
161: SELECT SUBSTR(INITCAP(RTRIM(ppf.title)||' '||RTRIM(ppf.first_name)||' '||RTRIM(ppf.last_name)),1,60)
162: FROM per_addresses addr,
163: per_people_f ppf
164: WHERE ppf.person_id = IN_payee_id
165: AND ppf.business_group_id+0 = IN_business_group_id
166: AND IN_payment_date BETWEEN ppf.effective_start_date

Line 513: address_record per_addresses%rowtype;

509: f_addr_line1 varchar2(240) := NULL;
510: f_addr_line2 varchar2(240) := NULL;
511: f_city_state_zip varchar2(250) := NULL;
512: --
513: address_record per_addresses%rowtype;
514: cursor get_address_record is
515: select * from per_addresses
516: where person_id = p_person_id
517: and primary_flag='Y'

Line 515: select * from per_addresses

511: f_city_state_zip varchar2(250) := NULL;
512: --
513: address_record per_addresses%rowtype;
514: cursor get_address_record is
515: select * from per_addresses
516: where person_id = p_person_id
517: and primary_flag='Y'
518: and nvl(date_to, p_effective_date) >= p_effective_date;
519: --

Line 564: -- address_record per_addresses%rowtype;

560: --
561: f_address varchar2(340) := NULL;
562:
563: --
564: -- address_record per_addresses%rowtype;
565: --
566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;

Line 566: v_address_line1 per_addresses.address_line1%TYPE;

562:
563: --
564: -- address_record per_addresses%rowtype;
565: --
566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;

Line 567: v_address_line2 per_addresses.address_line2%TYPE;

563: --
564: -- address_record per_addresses%rowtype;
565: --
566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;
571: v_postal_code per_addresses.postal_code%TYPE;

Line 568: v_address_line3 per_addresses.address_line3%TYPE;

564: -- address_record per_addresses%rowtype;
565: --
566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;
571: v_postal_code per_addresses.postal_code%TYPE;
572: --

Line 569: v_town_or_city per_addresses.town_or_city%TYPE;

565: --
566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;
571: v_postal_code per_addresses.postal_code%TYPE;
572: --
573: cursor get_address_record is

Line 570: v_region_2 per_addresses.region_2%TYPE;

566: v_address_line1 per_addresses.address_line1%TYPE;
567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;
571: v_postal_code per_addresses.postal_code%TYPE;
572: --
573: cursor get_address_record is
574: select address_line1, address_line2, address_line3,

Line 571: v_postal_code per_addresses.postal_code%TYPE;

567: v_address_line2 per_addresses.address_line2%TYPE;
568: v_address_line3 per_addresses.address_line3%TYPE;
569: v_town_or_city per_addresses.town_or_city%TYPE;
570: v_region_2 per_addresses.region_2%TYPE;
571: v_postal_code per_addresses.postal_code%TYPE;
572: --
573: cursor get_address_record is
574: select address_line1, address_line2, address_line3,
575: town_or_city, region_2, postal_code

Line 576: from per_addresses

572: --
573: cursor get_address_record is
574: select address_line1, address_line2, address_line3,
575: town_or_city, region_2, postal_code
576: from per_addresses
577: where person_id = p_person_id
578: and primary_flag = 'Y'
579: and nvl(date_to, sysdate) >= sysdate;
580: --

Line 1759: -- address_record per_addresses%rowtype;

1755: p_address out nocopy varchar2) IS
1756: --
1757: f_address varchar2(300) := NULL;
1758: --
1759: -- address_record per_addresses%rowtype;
1760: --
1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;

Line 1761: v_address_line1 per_addresses.address_line1%TYPE;

1757: f_address varchar2(300) := NULL;
1758: --
1759: -- address_record per_addresses%rowtype;
1760: --
1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;

Line 1762: v_address_line2 per_addresses.address_line2%TYPE;

1758: --
1759: -- address_record per_addresses%rowtype;
1760: --
1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;
1766: v_postal_code per_addresses.postal_code%TYPE;

Line 1763: v_address_line3 per_addresses.address_line3%TYPE;

1759: -- address_record per_addresses%rowtype;
1760: --
1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;
1766: v_postal_code per_addresses.postal_code%TYPE;
1767: --

Line 1764: v_town_or_city per_addresses.town_or_city%TYPE;

1760: --
1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;
1766: v_postal_code per_addresses.postal_code%TYPE;
1767: --
1768: cursor get_address_record is

Line 1765: v_region_2 per_addresses.region_2%TYPE;

1761: v_address_line1 per_addresses.address_line1%TYPE;
1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;
1766: v_postal_code per_addresses.postal_code%TYPE;
1767: --
1768: cursor get_address_record is
1769: select address_line1, address_line2, address_line3,

Line 1766: v_postal_code per_addresses.postal_code%TYPE;

1762: v_address_line2 per_addresses.address_line2%TYPE;
1763: v_address_line3 per_addresses.address_line3%TYPE;
1764: v_town_or_city per_addresses.town_or_city%TYPE;
1765: v_region_2 per_addresses.region_2%TYPE;
1766: v_postal_code per_addresses.postal_code%TYPE;
1767: --
1768: cursor get_address_record is
1769: select address_line1, address_line2, address_line3,
1770: town_or_city, region_2, postal_code

Line 1771: from per_addresses

1767: --
1768: cursor get_address_record is
1769: select address_line1, address_line2, address_line3,
1770: town_or_city, region_2, postal_code
1771: from per_addresses
1772: where person_id = p_person_id
1773: and primary_flag = 'Y'
1774: and nvl(date_to, sysdate) >= sysdate;
1775: --