APPS.OKL_TXS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1596: FROM hr_all_organization_units

1592: l_dummy_var VARCHAR2(1) := '?' ;
1593:
1594: CURSOR okl_txsv_org_id_fk_csr (p_id IN NUMBER) IS
1595: SELECT 'x'
1596: FROM hr_all_organization_units
1597: WHERE organization_id = p_id;
1598: BEGIN
1599:
1600: IF (p_txsv_rec.org_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.org_id IS NOT NULL)

Line 1614: 'hr_all_organization_units');

1610: 'org_id',
1611: g_child_table_token ,
1612: 'OKL_TAX_SOURCES_V',
1613: g_parent_table_token ,
1614: 'hr_all_organization_units');
1615: l_return_status := OKC_API.G_RET_STS_ERROR;
1616:
1617: END IF;
1618: