APPS.PER_KW_XDO_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 174: FROM hr_organization_units

170: IF p_business_group_id IS NOT NULL THEN
171: BEGIN
172: SELECT name
173: INTO l_org_name
174: FROM hr_organization_units
175: WHERE organization_id = p_business_group_id;
176: EXCEPTION
177: WHEN OTHERS THEN
178: NULL;

Line 231: FROM hr_organization_units

227: IF p_legal_employer IS NOT NULL THEN
228: BEGIN
229: SELECT name
230: INTO l_legal_employer
231: FROM hr_organization_units
232: WHERE organization_id = p_legal_employer;
233: EXCEPTION
234: WHEN OTHERS THEN
235: NULL;

Line 670: FROM hr_organization_units

666: IF p_business_group_id IS NOT NULL THEN
667: BEGIN
668: SELECT name
669: INTO l_org_name
670: FROM hr_organization_units
671: WHERE organization_id = p_business_group_id;
672: EXCEPTION
673: WHEN OTHERS THEN
674: NULL;

Line 715: FROM hr_organization_units

711: IF p_legal_employer IS NOT NULL THEN
712: BEGIN
713: SELECT name
714: INTO l_legal_employer
715: FROM hr_organization_units
716: WHERE organization_id = p_legal_employer;
717: EXCEPTION
718: WHEN OTHERS THEN
719: NULL;