879: AND pos.date_start = v_ud_per.effective_start_date;
880:
881: SELECT pos.period_of_service_id
882: INTO l_period_of_service_id
883: FROM hr_h2pi_periods_of_service_v pos
884: WHERE pos.person_id = l_person_id
885: AND pos.date_start = l_esd;
886:
887: hr_h2pi_map.create_id_mapping
1116: AND pos.date_start = v_ud_per.effective_start_date ;
1117:
1118: SELECT pos.period_of_service_id
1119: INTO l_period_of_service_id
1120: FROM hr_h2pi_periods_of_service_v pos
1121: WHERE pos.person_id = l_person_id
1122: AND pos.date_start = l_esd ;
1123:
1124: hr_h2pi_map.create_id_mapping