APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_GENERAL

Line 625: AND pce.business_group_id = decode(hr_general.get_xbg_profile,

621: per_all_people_f ppf
622: WHERE pce.type = 'REQUIREMENT'
623: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
624: and nvl(pce.effective_date_to, trunc(sysdate))
625: AND pce.business_group_id = decode(hr_general.get_xbg_profile,
626: 'Y', pce.business_group_id, ppf.business_group_id)
627: AND pce.competence_id = pcp.competence_id
628: AND pcp.mandatory = p_person_id
629: AND ppf.person_id = pcp.mandatory