[Home] [Help]
1173: exit;
1174: End loop;
1175: Else -- read from history
1176: l_personal_analysis_id := Null;
1177: ghr_history_fetch.return_special_information
1178: (p_person_id => p_pa_request_rec.person_id,
1179: p_structure_name => 'US Fed Education',
1180: p_effective_date => p_pa_request_rec.effective_date,
1181: p_special_info => l_special_info
1604: IF l_NTE_Dates IS NULL THEN
1605: /* FOR l_Cur_NTE_date_bef_np in Cur_NTE_date_bef_np(p_pa_request_rec.person_id,l_np_eff_date) LOOP
1606: l_NTE_Dates := l_Cur_NTE_date_bef_np.NTE_Dates;
1607: END LOOP; */
1608: ghr_history_fetch.fetch_asgei ( p_assignment_id => p_pa_request_rec.employee_assignment_id,
1609: p_information_type => 'GHR_US_ASG_NTE_DATES',
1610: p_date_effective => (l_np_eff_date-1),
1611: p_asg_ei_data => l_asg_ei_data
1612: );
3828: END LOOP;
3829: hr_utility.set_location('Assg Pos ' ||l_asg_position,599);
3830:
3831: --Getting Grade id
3832: ghr_history_fetch.fetch_positionei
3833: (p_position_id => l_position_id
3834: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
3835: ,p_date_effective => p_pa_request_rec.effective_date
3836: ,p_pos_ei_data => l_pos_ei_data);
6135: -- Bug#5666880 - Included NOA 896, 897
6136: IF (p_pa_request_rec.first_noa_code IN ('892','867','896','897') OR
6137: p_pa_request_rec.second_noa_code IN ('892','867','896','897')) THEN
6138: hr_utility.set_location('inside NOA Code 897',9999999);
6139: ghr_history_fetch.fetch_element_entry_value
6140: (p_element_name => 'Within Grade Increase',
6141: p_input_value_name => 'Last Equivalent Increase',
6142: p_assignment_id => p_pa_request_rec.employee_assignment_id,
6143: p_date_effective => p_pa_request_rec.effective_date,
6149: -- Bug 3709414 Retrieving Last equivalent increase date if it's not entered in RPA EIT.
6150: hr_utility.set_location('p_wgi.p_last_equi_incr is ' || p_wgi.p_last_equi_incr,1);
6151: IF (p_pa_request_rec.first_noa_code = '713' OR p_pa_request_rec.second_noa_code = '713')
6152: AND p_wgi.p_last_equi_incr IS NULL THEN
6153: ghr_history_fetch.fetch_element_entry_value
6154: (p_element_name => 'Within Grade Increase',
6155: p_input_value_name => 'Last Equivalent Increase',
6156: p_assignment_id => p_pa_request_rec.employee_assignment_id,
6157: p_date_effective => p_pa_request_rec.effective_date,
7925: l_step_or_rate := next_from_step.to_step;
7926: end loop;
7927: Else
7928: -- get the user table id for the position in all other cases .
7929: ghr_history_fetch.fetch_positionei
7930: (
7931: p_position_id => p_pa_request_rec.to_position_id
7932: ,p_information_type => 'GHR_US_POS_VALID_GRADE'
7933: ,p_date_effective => p_pa_request_rec.effective_date
8114: THEN
8115: hr_utility.set_location('Do not calc. WGI Dates for all steps in QSI ',1);
8116: -- Start of Bug 3111719
8117: -- Return the current WGI due date for steps other than 4,7,10 in QSI.
8118: ghr_history_fetch.fetch_element_entry_value
8119: (p_element_name => 'Within Grade Increase',
8120: p_input_value_name => 'Date Due',
8121: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8122: p_date_effective => p_pa_request_rec.effective_date,
8127: -- End of Bug 3111719.
8128: -- Bug 3709414 New Approach-- For 713 actions take from element entry
8129: -- If DLEI is entered, use that to calculate Due Date, else retain the old date
8130: ELSIF (p_pa_request_rec.first_noa_code = '713' OR p_pa_request_rec.second_noa_code = '713') AND p_dlei IS NULL THEN
8131: ghr_history_fetch.fetch_element_entry_value
8132: (p_element_name => 'Within Grade Increase',
8133: p_input_value_name => 'Date Due',
8134: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8135: p_date_effective => p_pa_request_rec.effective_date,
8145: end loop;
8146: If (p_pa_request_rec.first_noa_code = '892' or p_pa_request_rec.second_noa_code = '892') and
8147: (p_retained_grade_rec.step_or_rate in (4,7) or l_from_step in (4,7)) then
8148: -- get current WGI Due Date
8149: ghr_history_fetch.fetch_element_entry_value
8150: (p_element_name => 'Within Grade Increase',
8151: p_input_value_name => 'Date Due',
8152: p_assignment_id => p_pa_request_rec.employee_assignment_id,
8153: p_date_effective => p_pa_request_rec.effective_date,