APPS.GHR_CPDF_EHRIS dependencies on HR_GENERAL

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

3389: (p_agencies_with_se is not null and INSTR(p_agencies_with_se,ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1) > 0)
3390: OR
3391: (p_agencies_without_se is not null and INSTR(p_agencies_without_se,substr(ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id),1,2),1) > 0)
3392: )
3393: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , hr_general.get_business_group_id) = asg.business_group_id
3394: ORDER BY assignment_id;
3395: -- Bug 3704123 - Adding order by clause for the above statement so that results will be in temp segment
3396:
3397: l_all_assignments_rec all_assignments_cur%ROWTYPE;