APPS.PER_AE_XDO_REPORT dependencies on HR_ORGANIZATION_UNITS

Line 140: FROM hr_organization_units

136: IF p_business_group_id IS NOT NULL THEN
137: BEGIN
138: SELECT name
139: INTO l_org_name
140: FROM hr_organization_units
141: WHERE organization_id = p_business_group_id;
142: EXCEPTION
143: WHEN OTHERS THEN
144: NULL;

Line 518: FROM hr_organization_units

514: IF p_business_group_id IS NOT NULL THEN
515: BEGIN
516: SELECT name
517: INTO l_org_name
518: FROM hr_organization_units
519: WHERE organization_id = p_business_group_id;
520: EXCEPTION
521: WHEN OTHERS THEN
522: NULL;

Line 941: FROM hr_organization_units

937: IF /*p_business_group_id*/ p_org_id IS NOT NULL THEN
938: BEGIN
939: SELECT name
940: INTO l_org_name
941: FROM hr_organization_units
942: WHERE organization_id =/* p_business_group_id*/ p_org_id ;
943: EXCEPTION
944: WHEN OTHERS THEN
945: NULL;