653: ,p_noa_id_corrected => l_noa_id
654: ,p_date_effective => p_effective_date
655: ,p_assignment_data => l_asgn_data);
656: --
657: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
658: ,l_duty_station_id);
659: --
660: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
661: ,p_effective_date
656: --
657: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_asgn_data.location_id
658: ,l_duty_station_id);
659: --
660: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
661: ,p_effective_date
662: ,l_duty_station_code
663: ,l_dummy_varchar);
664: p_from_duty_station_code := l_duty_station_code;
713: ,p_duty_station_location_id => l_location_id
714: ,p_pay_rate_determinant => p_from_pay_rate_determinant
715: ,p_work_schedule => p_from_work_schedule);
716: --
717: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
718: ,l_duty_station_id);
719:
720: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
721: ,p_effective_date
716: --
717: ghr_pa_requests_pkg.get_SF52_loc_ddf_details (l_location_id
718: ,l_duty_station_id);
719:
720: ghr_pa_requests_pkg.get_duty_station_details (l_duty_station_id
721: ,p_effective_date
722: ,l_duty_station_code
723: ,l_dummy_varchar);
724: p_from_duty_station_code := l_duty_station_code;
1439: --End Bug# 4648811
1440:
1441: --Bug # 9329643
1442: If l_ghr_pa_requests_rec.person_id is not null then
1443: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
1444: (p_person_id => l_ghr_pa_requests_rec.person_id,
1445: p_effective_date => l_ghr_pa_requests_rec.effective_date);
1446: End if;
1447:
1539: /*GHR_PROCESS_SF52.get_family_code(l_ghr_pa_requests_rec.second_noa_id,
1540: l_noa_family_code);*/
1541:
1542: --Bug # 7507154 added this call to get the family code based on Effective date
1543: l_noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1544: (l_ghr_pa_requests_rec.second_noa_id,
1545: l_ghr_pa_requests_rec.effective_date);
1546: EXCEPTION
1547: WHEN OTHERS THEN