5085: RETURN VARCHAR2 is
5086:
5087: Cursor Cr_Org_name is
5088: Select Org.Name Org_name
5089: from Hr_all_Positions_F pos, hr_all_organization_units_tl Org
5090: where position_id = p_position_id
5091: and org.organization_id = pos.organization_id
5092: and language = userenv('LANG');
5093:
5090: where position_id = p_position_id
5091: and org.organization_id = pos.organization_id
5092: and language = userenv('LANG');
5093:
5094: l_org_name hr_all_organization_units_tl.Name%TYPE := NULL;
5095: Begin
5096: If p_position_id is NOT NULL Then
5097: Open Cr_Org_Name;
5098: Fetch Cr_Org_name into l_org_name;