DBA Data[Home] [Help]

APPS.OKS_TAX_UTIL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

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