eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on HR_ORGANIZATION_UNITS_V

Line 529: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE

525: FUNCTION GET_LOCATION_CODE
526: (
527: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,
528: p_organization_id IN pqh_budget_details.organization_id%TYPE,
529: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE
530: ) RETURN VARCHAR
531: IS
532: l_location_code VARCHAR2(30);
533: BEGIN

Line 537: from hr_organization_units_v

533: BEGIN
534: IF(p_entity_code = 'POSITION' OR p_entity_code = 'ORGANIZATION') then
535: select location_code
536: into l_location_code
537: from hr_organization_units_v
538: where organization_id = p_organization_id;
539: ELSE
540: select location_code
541: into l_location_code

Line 542: from hr_organization_units_v

538: where organization_id = p_organization_id;
539: ELSE
540: select location_code
541: into l_location_code
542: from hr_organization_units_v
543: where organization_id= p_business_group_id;
544: END IF;
545: RETURN l_location_code;
546: EXCEPTION