APPS.PO_CORE_S3 dependencies on HR_ORGANIZATION_UNITS

Line 65: FROM hr_organization_units hou

61: /* Bug 1040332, zxzhang, substr is dependent on character set */
62: /*SELECT substr(hou.name,1,30)*/
63: SELECT substrb(hou.name,1,30)
64: INTO x_org_sob_name
65: FROM hr_organization_units hou
66: WHERE hou.organization_id = x_org_sob_id;
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: null;

Line 120: FROM hr_organization_units hou

116: /* Bug 1040332, zxzhang, substr is dependent on character set */
117: /*SELECT substr(hou.name,1,30)*/
118: SELECT substrb(hou.name,1,30)
119: INTO x_org_sob_name
120: FROM hr_organization_units hou
121: WHERE hou.organization_id = x_org_sob_id;
122:
123: else
124: