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 391: l_organization_name hr_organization_units.name%TYPE;

387: --
388:
389: c_item_name varchar2(40);
390: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
391: l_organization_name hr_organization_units.name%TYPE;
392: l_person_id number(10);
393: l_locality_company_id varchar2(50);
394: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
395: l_effective_date date;

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

529: sp_out_10 OUT nocopy varchar2
530: ) RETURN VARCHAR2 IS
531:
532: /* Philadelphi Locality Company Id */
533: CURSOR get_locality_company_id(c_tax_unit_id hr_organization_units.organization_id%type)
534: IS
535: select org_information2
536: from hr_organization_information hoi
537: WHERE hoi.organization_id = c_tax_unit_id

Line 999: (c_organization_id hr_organization_units.organization_id%type,

995: p_source_type IN varchar2)
996: RETURN organization_name_address
997: IS
998: CURSOR get_organization_name_address
999: (c_organization_id hr_organization_units.organization_id%type,
1000: c_effective_date date)
1001: IS
1002: SELECT hou.name org_name ,
1003: hl.address_line_1,