APPS.GHR_EEOC_STATUS_REPORT dependencies on GHR_HISTORY_FETCH

Line 233: ghr_history_fetch.fetch_peopleei(p_person_id => p_person_id,

229: hr_utility.set_location('Entering:'||l_proc,5);
230:
231: g_message_name := 'Person EIT: Person Group1';
232: l_perei_data := null;
233: ghr_history_fetch.fetch_peopleei(p_person_id => p_person_id,
234: p_information_type => 'GHR_US_PER_GROUP1',
235: p_date_effective => p_report_date,
236: p_per_ei_data => l_perei_data
237: );

Line 252: ghr_history_fetch.fetch_peopleei(p_person_id => p_person_id,

248:
249:
250: g_message_name := 'Person EIT: Person SCD Info';
251: l_perei_data := null;
252: ghr_history_fetch.fetch_peopleei(p_person_id => p_person_id,
253: p_information_type => 'GHR_US_PER_SCD_INFORMATION',
254: p_date_effective => p_report_date,
255: p_per_ei_data => l_perei_data
256: );

Line 263: ghr_history_fetch.fetch_peopleei (p_person_id => p_person_id,

259: IF p_report_date >= TO_DATE('01/07/2006','DD/MM/RRRR') THEN
260:
261: g_message_name := 'Person EIT: Ethnicity, Race';
262: l_perei_data := null;
263: ghr_history_fetch.fetch_peopleei (p_person_id => p_person_id,
264: p_information_type => 'GHR_US_PER_ETHNICITY_RACE',
265: p_date_effective => p_report_date,
266: p_per_ei_data => l_perei_data
267: );

Line 306: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,

302: BEGIN
303: hr_utility.set_location('Entering:'||l_proc,5);
304: g_message_name := 'Position EIT: Position Group1';
305: l_posei_data := NULL;
306: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,
307: p_information_type => 'GHR_US_POS_GRP1',
308: p_date_effective => p_report_date,
309: p_pos_ei_data => l_posei_data
310: );

Line 316: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,

312:
313: IF g_temp_rec.to_pay_basis is NULL THEN
314: g_message_name := 'Position EIT: Valid Grade';
315: l_posei_data := NULL;
316: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,
317: p_information_type => 'GHR_US_POS_VALID_GRADE',
318: p_date_effective => p_report_date,
319: p_pos_ei_data => l_posei_data
320: );

Line 326: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,

322: END IF;
323:
324: g_message_name := 'Position EIT: Position Group2';
325: l_posei_data := NULL;
326: ghr_history_fetch.fetch_positionei(p_position_id => p_position_id,
327: p_information_type => 'GHR_US_POS_GRP2',
328: p_date_effective => p_report_date,
329: p_pos_ei_data => l_posei_data);
330: hr_utility.set_location('mani l_posei_data.poei_information17'||l_posei_data.poei_information17,100);

Line 350: GHR_HISTORY_FETCH.fetch_asgei(p_assignment_id => p_assignment_id,

346: hr_utility.set_location('Entering:'||l_proc,5);
347:
348: g_message_name := 'Assignment EIT: Asg SF52';
349: l_asgnei_data := NULL;
350: GHR_HISTORY_FETCH.fetch_asgei(p_assignment_id => p_assignment_id,
351: p_information_type => 'GHR_US_ASG_SF52',
352: p_date_effective => p_report_date,
353: p_asg_ei_data => l_asgnei_data);
354:

Line 360: GHR_HISTORY_FETCH.fetch_asgei(p_assignment_id => p_assignment_id,

356: g_temp_rec.to_step_or_rate := l_asgnei_data.aei_information3;
357: g_temp_rec.to_pay_rate_determinant := l_asgnei_data.aei_information6;
358:
359: l_asgnei_data := NULL;
360: GHR_HISTORY_FETCH.fetch_asgei(p_assignment_id => p_assignment_id,
361: p_information_type => 'GHR_US_ASG_NON_SF52',
362: p_date_effective => p_report_date,
363: p_asg_ei_data => l_asgnei_data);
364: g_temp_rec.pay_status := l_asgnei_data.aei_information14;