APPS.GHR_EEOC_STATUS_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 38: FROM PER_ALL_ASSIGNMENTS_F asg, PER_ASSIGNMENT_STATUS_TYPES ast

34: asg.effective_start_date,
35: asg.business_group_id,
36: ast.per_system_status assignment_status_type,
37: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code
38: FROM PER_ALL_ASSIGNMENTS_F asg, PER_ASSIGNMENT_STATUS_TYPES ast
39: WHERE ast.assignment_status_type_id = asg.assignment_status_type_id
40: AND p_report_date > asg.effective_start_date
41: AND TO_CHAR(asg.effective_end_date,'YYYY') >= to_char(p_report_date,'YYYY')
42: AND ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 47: AND effective_start_date = (select max(effective_start_date) from PER_ALL_ASSIGNMENTS_F asg1, PER_ASSIGNMENT_STATUS_TYPES ast1

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
51: AND TO_CHAR(asg1.effective_end_date,'YYYY') >= to_char(p_report_date,'YYYY')