APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 390: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;

386: -- Local Variable Declaration
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;

Line 541: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;

537: WHERE hoi.organization_id = c_tax_unit_id
538: and hoi.org_information_context = 'Local Tax Rules'
539: AND hoi.org_information1 = '39-101-3000';
540:
541: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
542: c_item_name varchar2(40);
543: l_emp_number varchar2(40);
544: l_locality_company_id varchar2(50);
545: lr_employer_addr pay_us_get_item_data_pkg.organization_name_address;

Line 1017: hr_all_organization_units hou

1013: hl.region_2,
1014: 'Y' valid_address
1015: FROM hr_locations_all hl,
1016: hr_lookups hrl,
1017: hr_all_organization_units hou
1018: WHERE hou.organization_id = c_organization_id
1019: AND hl.location_id = hou.location_id
1020: AND nvl(hl.inactive_date,end_date)>= c_effective_date
1021: AND hrl.lookup_code (+)=hl.country