APPS.GHR_EEOC_STATUS_REPORT dependencies on GHR_API

Line 37: ghr_api.get_position_agency_code_pos(asg.position_id,asg.business_group_id) agency_code

33: asg.location_id,
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')

Line 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,'%')

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')
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

Line 55: AND ghr_api.get_position_agency_code_pos(asg1.position_id,asg1.business_group_id) like p_agency_code||NVL(p_agency_sub_code,'%'))

51: AND TO_CHAR(asg1.effective_end_date,'YYYY') >= to_char(p_report_date,'YYYY')
52: AND ast1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
53: AND asg1.assignment_type <> 'B'
54: AND asg1.position_id IS NOT NULL
55: AND ghr_api.get_position_agency_code_pos(asg1.position_id,asg1.business_group_id) like p_agency_code||NVL(p_agency_sub_code,'%'))
56: ORDER BY assignment_id;
57:
58: BEGIN
59:

Line 92: g_temp_rec.to_occ_code := GHR_API.GET_JOB_OCC_SERIES_JOB(p_job_id => l_ass_rec.job_id,

88:
89: BEGIN
90: g_message_name := 'Occupational Series';
91:
92: g_temp_rec.to_occ_code := GHR_API.GET_JOB_OCC_SERIES_JOB(p_job_id => l_ass_rec.job_id,
93: p_business_group_id => p_business_group);
94:
95: FETCH_ASGEI_DETAILS(p_assignment_id => l_ass_rec.assignment_id,
96: p_report_date => p_report_date);

Line 110: ghr_api.return_education_details(p_person_id => l_ass_rec.person_id,

106:
107:
108:
109: g_message_name := 'Special Info: Education Dtls';
110: ghr_api.return_education_details(p_person_id => l_ass_rec.person_id,
111: p_effective_date => p_report_date,
112: p_education_level => g_temp_rec.education_level,
113: p_academic_discipline => g_temp_rec.academic_discipline,
114: p_year_degree_attained => g_temp_rec.year_degree_attained);