APPS.HR_US_REPORTS dependencies on HR_ORGANIZATION_UNITS

Line 840: FROM hr_organization_units

836: begin
837: hr_utility.set_location('hr_us_reports.get_tax_unit',5);
838: SELECT name
839: INTO l_tax_unit_name
840: FROM hr_organization_units
841: WHERE organization_id = p_tax_unit_id;
842: --
843: exception when NO_DATA_FOUND then RETURN NULL;
844: end;

Line 1286: hr_organization_units hou

1282: /* Bug No 4350592
1283: SELECT decode(tax_unit_id,'','N','Y')
1284: INTO tax_unit_flag
1285: FROM hr_tax_units_v htuv,
1286: hr_organization_units hou
1287: WHERE htuv.tax_unit_id(+) = hou.organization_id
1288: AND hou.organization_id = parent_tax_unit_id;
1289: */
1290: END LOOP;

Line 1354: hr_organization_units hou

1350: /* previous */
1351: /*cursor csr_tax_unit_flag(p_tax_unit_id number) is -- Bug 3624095
1352: SELECT htuv.tax_unit_id
1353: FROM hr_tax_units_v htuv,
1354: hr_organization_units hou
1355: WHERE htuv.tax_unit_id(+) = hou.organization_id
1356: AND hou.organization_id = p_tax_unit_id;
1357: */--
1358: --

Line 1406: hr_organization_units hou

1402: --
1403: SELECT decode(hr_tax_unit_id,'','N','Y')
1404: INTO hr_tax_unit_flag
1405: FROM hr_tax_units_v htuv,
1406: hr_organization_units hou
1407: WHERE htuv.tax_unit_id(+) = hou.organization_id
1408: AND hou.organization_id = parent_hr_tax_unit_id;
1409: */
1410: --

Line 1500: FROM hr_organization_units

1496: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);
1497: --
1498: SELECT name
1499: INTO l_org_name
1500: FROM hr_organization_units
1501: WHERE organization_id = p_organization_id
1502: AND business_group_id + 0 = p_business_group_id;
1503: --
1504: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);