899: ,p_noa_id_corrected => l_noa_id
900: ,p_date_effective => p_effective_date
901: ,p_assignment_data => l_asgn_data);
902: --
903: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
904: ,l_duty_station_id);
905: --
906: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
907: ,p_effective_date
902: --
903: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
904: ,l_duty_station_id);
905: --
906: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
907: ,p_effective_date
908: ,l_duty_station_code
909: ,l_dummy_varchar);
910: p_from_duty_station_code := l_duty_station_code;
959: ,p_duty_station_location_id => l_location_id
960: ,p_pay_rate_determinant => p_from_pay_rate_determinant
961: ,p_work_schedule => p_from_work_schedule);
962: --
963: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
964: ,l_duty_station_id);
965:
966: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
967: ,p_effective_date
962: --
963: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
964: ,l_duty_station_id);
965:
966: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
967: ,p_effective_date
968: ,l_duty_station_code
969: ,l_dummy_varchar);
970: p_from_duty_station_code := l_duty_station_code;
2762: IF l_noa_family_code = 'CORRECT' THEN
2763: -- Bug#2789704 Added Exception Handling
2764: -- Bug#5172710 Modified the function to determine the noa family code.
2765: BEGIN
2766: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
2767: (l_ghr_pa_requests_rec.second_noa_id,
2768: l_ghr_pa_requests_rec.effective_date);
2769: EXCEPTION
2770: WHEN OTHERS THEN