DBA Data[Home] [Help]

APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_PERIODS_OF_SERVICE_V

Line 883: FROM hr_h2pi_periods_of_service_v pos

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

Line 1120: FROM hr_h2pi_periods_of_service_v pos

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