APPS.ARP_RECON_REP dependencies on HR_ORGANIZATION_UNITS

Line 528: from hr_organization_units hou

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

Line 1052: from hr_organization_units hou

1048: /* Get the org name */
1049: IF p_reporting_level = '3000' THEN
1050: select substrb(hou.name,1,60)
1051: into l_organization
1052: from hr_organization_units hou
1053: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
1054: ELSE
1055: select meaning
1056: into l_organization

Line 2269: from hr_organization_units hou

2265: /* Get the org name */
2266: IF p_reporting_level = '3000' THEN
2267: select substrb(hou.name,1,60)
2268: into l_organization
2269: from hr_organization_units hou
2270: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
2271: ELSE
2272: select meaning
2273: into l_organization

Line 3340: from hr_organization_units hou

3336:
3337: IF p_reporting_level = '3000' THEN
3338: select substrb(hou.name,1,60)
3339: into l_organization
3340: from hr_organization_units hou
3341: where hou.organization_id = arp_recon_rep.var_tname.g_reporting_entity_id;
3342: ELSE
3343: select meaning
3344: into l_organization