APPS.PO_CORE_S3 dependencies on HR_ORGANIZATION_UNITS

Line 66: FROM hr_organization_units hou

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

Line 121: FROM hr_organization_units hou

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