APPS.GHR_EEOC_DYNAMICS_REPORT dependencies on HR_GENERAL

Line 42: AND decode(hr_general.get_xbg_profile,'Y',per.business_group_id ,p_business_group) = per.business_group_id;

38: where altered_pa_request_id = par.pa_request_id
39: and pa_notification_id is not null
40: and first_noa_code = '001'
41: and second_noa_code = par.first_noa_code)
42: AND decode(hr_general.get_xbg_profile,'Y',per.business_group_id ,p_business_group) = per.business_group_id;
43:
44: CURSOR get_awd_amount(p_pa_request_id in number)
45: is
46: select award_amount

Line 464: l_business_group := hr_general.get_business_group_id;

460:
461: l_ret_code := 0;
462:
463: IF p_business_group is NULL then
464: l_business_group := hr_general.get_business_group_id;
465: ELSE
466: l_business_group := p_business_group;
467: END IF;
468: