APPS.GHR_EEOC_STATUS_REPORT dependencies on HR_GENERAL

Line 46: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , p_business_group) = asg.business_group_id

42: AND ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
43: AND asg.assignment_type <> 'B'
44: AND asg.position_id IS NOT NULL
45: AND ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) like p_agency_code||NVL(p_agency_sub_code,'%')
46: AND decode(hr_general.get_xbg_profile,'Y',asg.business_group_id , p_business_group) = asg.business_group_id
47: AND effective_start_date = (select max(effective_start_date) from PER_ALL_ASSIGNMENTS_F asg1, PER_ASSIGNMENT_STATUS_TYPES ast1
48: WHERE asg1.assignment_id = asg.assignment_id
49: AND ast1.assignment_status_type_id = asg1.assignment_status_type_id
50: AND p_report_date > asg1.effective_start_date

Line 922: l_business_group := hr_general.get_business_group_id;

918: (userenv('sessionid')
919: ,l_report_date);
920:
921: IF p_business_group is NULL then
922: l_business_group := hr_general.get_business_group_id;
923: ELSE
924: l_business_group := p_business_group;
925: END IF;
926: