DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on GHR_HISTORY_FETCH

Line 1209: ghr_history_fetch.fetch_asgei (

1205: --
1206: -- START fix for 3563491 Madhuri
1207: --
1208: IF (p_pa_request_rec.noa_family_code = 'EXT_NTE') THEN
1209: ghr_history_fetch.fetch_asgei (
1210: p_assignment_id =>p_pa_request_rec.employee_assignment_id ,
1211: p_information_type => 'GHR_US_ASG_NTE_DATES' ,
1212: p_date_effective => nvl(p_pa_request_rec.effective_date,trunc(sysdate)) ,
1213: p_asg_ei_data => l_asg_ei_data

Line 1290: ghr_history_fetch.fetch_peopleei

1286: -- added for Student Loan Repayment Changes - 3494728 bug
1287: IF ( p_pa_request_rec.first_noa_code = '817' or p_pa_request_rec.second_noa_code = '817') THEN
1288:
1289: --3562069
1290: ghr_history_fetch.fetch_peopleei
1291: (p_person_id => p_pa_request_rec.person_id,
1292: p_information_type => 'GHR_US_PER_GROUP1',
1293: p_date_effective => nvl(p_pa_request_rec.effective_date,trunc(sysdate)),
1294: p_per_ei_data => l_per_ei_data

Line 2099: ghr_history_fetch.fetch_positionei(

2095: l_user_table_id := ghr_pay_calc.get_user_table_id (p_pa_request_rec.to_position_id
2096: ,NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)) );
2097: --Start of the Bug 3604377
2098: -- Retive the Grade info from the POI history table
2099: ghr_history_fetch.fetch_positionei(
2100: p_position_id => p_pa_request_rec.to_position_id,
2101: p_information_type => 'GHR_US_POS_VALID_GRADE',
2102: p_date_effective => NVL(p_pa_request_rec.effective_date,TRUNC(sysdate)),
2103: p_pos_ei_data => l_pos_ei_grade_data);