APPS.ARP_RECON_REP dependencies on HR_ORGANIZATION_UNITS

Line 527: from hr_organization_units hou

523: /* Get the org name */
524: IF p_reporting_level = '3000' THEN
525: select substrb(hou.name,1,60)
526: into l_organization
527: from hr_organization_units hou
528: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
529: ELSE
530: select meaning
531: into l_organization

Line 1036: from hr_organization_units hou

1032: /* Get the org name */
1033: IF p_reporting_level = '3000' THEN
1034: select substrb(hou.name,1,60)
1035: into l_organization
1036: from hr_organization_units hou
1037: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1038: ELSE
1039: select meaning
1040: into l_organization

Line 1629: from hr_organization_units hou

1625: /* Get the org name */
1626: IF p_reporting_level = '3000' THEN
1627: select substrb(hou.name,1,60)
1628: into l_organization
1629: from hr_organization_units hou
1630: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1631: ELSE
1632: select meaning
1633: into l_organization

Line 2127: from hr_organization_units hou

2123:
2124: IF p_reporting_level = '3000' THEN
2125: select substrb(hou.name,1,60)
2126: into l_organization
2127: from hr_organization_units hou
2128: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2129: ELSE
2130: select meaning
2131: into l_organization