APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 463: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;

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

Line 614: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;

610: WHERE hoi.organization_id = c_tax_unit_id
611: and hoi.org_information_context = 'Local Tax Rules'
612: AND hoi.org_information1 = '39-101-3000';
613:
614: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
615: c_item_name varchar2(40);
616: l_emp_number varchar2(40);
617: l_locality_company_id varchar2(50);
618: lr_employer_addr pay_us_get_item_data_pkg.organization_name_address;

Line 1135: hr_all_organization_units hou

1131: hl.telephone_number_1,
1132: 'Y' valid_address
1133: FROM hr_locations_all hl,
1134: hr_lookups hrl,
1135: hr_all_organization_units hou
1136: WHERE hou.organization_id = c_organization_id
1137: AND hl.location_id = hou.location_id
1138: AND nvl(hl.inactive_date,end_date)>= c_effective_date
1139: AND hrl.lookup_code (+)=hl.country