APPS.OKS_TAX_UTIL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1147: FROM HR_ALL_ORGANIZATION_UNITS

1143: /* code added for bug8323627 -- start */
1144: BEGIN
1145: SELECT location_id
1146: INTO l_bill_from_location_id
1147: FROM HR_ALL_ORGANIZATION_UNITS
1148: WHERE organization_id = p_rail_rec.org_id ;
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: l_bill_from_location_id := NULL;

Line 1635: FROM hr_all_organization_units_tl -- Bug 5036523 hr_operating_units

1631: PRECISION_REC cur_get_precision%ROWTYPE;
1632:
1633: CURSOR get_operating_unit(cp_org_id NUMBER) IS
1634: SELECT name
1635: FROM hr_all_organization_units_tl -- Bug 5036523 hr_operating_units
1636: WHERE organization_id = cp_org_id;
1637:
1638: G_RAIL_REC OKS_TAX_UTIL_PVT.ra_rec_type;
1639: l_okc_hdr_rec okc_hdr_csr%ROWTYPE;

Line 1652: l_op_unit_name hr_all_organization_units_tl.name%TYPE; --Bug 5036523 hr_operating_units.name%TYPE;

1648: l_doc_level_recalc_flag ZX_LINES_DET_FACTORS.threshold_indicator_flag%TYPE;
1649:
1650: l_default_tax_code VARCHAR2(50); /* npalepu 12-jul-2006, changed the tax_code field length from 30 to 50 for bug # 5380870 */
1651: l_need_header_tax VARCHAR2(1);
1652: l_op_unit_name hr_all_organization_units_tl.name%TYPE; --Bug 5036523 hr_operating_units.name%TYPE;
1653:
1654: --npalepu added on 28-jun-2006 for bug # 5223699
1655: l_subline_start_date okc_k_lines_b.start_date%TYPE;
1656: --end npalepu