APPS.GHR_CPDF_EHRIS dependencies on HR_GENERAL

Line 3253: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id

3249: AND ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3250: AND asg.assignment_type <> 'B'
3251: AND asg.position_id IS NOT NULL
3252: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency
3253: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
3254: ORDER BY assignment_id;
3255: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
3256:
3257: l_all_assignments_rec all_assignments_cur%ROWTYPE;