APPS.GHR_CPDF_STATRPT dependencies on HR_GENERAL

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

1270: where ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN'))
1271: AND asg.assignment_type <> 'B'
1272: AND asg.position_id IS NOT NULL
1273: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency
1274: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
1275: ORDER BY assignment_id;
1276: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
1277:
1278: l_assignments_f_rec assignments_f_cur%ROWTYPE;