APPS.HXC_TPD_END dependencies on HR_ORGANIZATION_UNITS

Line 1767: FROM hr_organization_units

1763: END IF;
1764:
1765: SELECT name
1766: INTO l_value
1767: FROM hr_organization_units
1768: WHERE organization_id = p_org_id
1769: AND ROWNUM < 2 ;
1770:
1771: g_org_name(TO_CHAR(p_org_id)) := l_value;