DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on HR_ALL_POSITIONS_F

Line 5083: p_position_id IN hr_all_positions_f.position_id%TYPE

5079: --
5080: --
5081: FUNCTION get_pos_org
5082: (
5083: p_position_id IN hr_all_positions_f.position_id%TYPE
5084: )
5085: RETURN VARCHAR2 is
5086:
5087: Cursor Cr_Org_name is

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: