DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 5089: from Hr_all_Positions_F pos, hr_all_organization_units_tl Org

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:

Line 5094: l_org_name hr_all_organization_units_tl.Name%TYPE := NULL;

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;