APPS.GHR_PA_REQUESTS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2482: SELECT org.name from hr_positions_f pos, hr_organization_units org

2478:
2479: l_proc varchar2(72) := 'get_pos_organization';
2480:
2481: CURSOR get_pos_org IS
2482: SELECT org.name from hr_positions_f pos, hr_organization_units org
2483: WHERE pos.organization_id = org.organization_id
2484: AND pos.business_group_id = p_business_group_id
2485: AND p_effective_date between pos.EFFECTIVE_START_DATE and pos.EFFECTIVE_END_DATE
2486: AND pos.position_id =p_position_id;