DBA Data[Home] [Help]

APPS.HR_SUIT_MATCH_UTIL_SS dependencies on HR_GENERAL

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

615: per_all_people_f ppf
616: WHERE pce.type = 'REQUIREMENT'
617: AND trunc(sysdate) between nvl(pce.effective_date_from, trunc(sysdate))
618: and nvl(pce.effective_date_to, trunc(sysdate))
619: AND pce.business_group_id = decode(hr_general.get_xbg_profile,
620: 'Y', pce.business_group_id, ppf.business_group_id)
621: AND pce.competence_id = pcp.competence_id
622: AND pcp.mandatory = p_person_id
623: AND ppf.person_id = pcp.mandatory