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_US_GET_ITEM_DATA_PKG dependencies on HR_ORGANIZATION_UNITS

Line 464: l_organization_name hr_organization_units.name%TYPE;

460: --
461:
462: c_item_name varchar2(40);
463: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
464: l_organization_name hr_organization_units.name%TYPE;
465: l_person_id number(10);
466: l_locality_company_id varchar2(50);
467: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
468: l_effective_date date;

Line 606: CURSOR get_locality_company_id(c_tax_unit_id hr_organization_units.organization_id%type)

602: sp_out_10 OUT nocopy varchar2
603: ) RETURN VARCHAR2 IS
604:
605: /* Philadelphi Locality Company Id */
606: CURSOR get_locality_company_id(c_tax_unit_id hr_organization_units.organization_id%type)
607: IS
608: select org_information2
609: from hr_organization_information hoi
610: WHERE hoi.organization_id = c_tax_unit_id

Line 1116: (c_organization_id hr_organization_units.organization_id%type,

1112: p_source_type IN varchar2)
1113: RETURN organization_name_address
1114: IS
1115: CURSOR get_organization_name_address
1116: (c_organization_id hr_organization_units.organization_id%type,
1117: c_effective_date date)
1118: IS
1119: SELECT hou.name org_name ,
1120: hl.address_line_1,