APPS.HR_PUMP_GET dependencies on PER_PERIODS_OF_SERVICE

Line 3547: from per_periods_of_service pps,

3543: l_period_of_service_id number;
3544: begin
3545: select pps.period_of_service_id
3546: into l_period_of_service_id
3547: from per_periods_of_service pps,
3548: hr_pump_batch_line_user_keys key
3549: where key.user_key_value = p_person_user_key
3550: and pps.person_id = key.unique_key_id
3551: and pps.business_group_id = p_business_group_id

Line 3572: from per_periods_of_service pps,

3568: l_period_of_service_id number;
3569: begin
3570: select pps.period_of_service_id
3571: into l_period_of_service_id
3572: from per_periods_of_service pps,
3573: hr_pump_batch_line_user_keys key
3574: where key.user_key_value = p_person_user_key
3575: and pps.person_id = key.unique_key_id
3576: and pps.business_group_id = p_business_group_id

Line 3602: from per_periods_of_service pps,

3598: begin
3599:
3600: select pps.period_of_service_id
3601: into l_period_of_service_id
3602: from per_periods_of_service pps,
3603: hr_pump_batch_line_user_keys key
3604: where key.user_key_value = p_person_user_key
3605: and pps.person_id = key.unique_key_id
3606: and pps.business_group_id = p_business_group_id

Line 4257: from per_periods_of_service pps,

4253: l_object_version_number number;
4254: begin
4255: select pps.object_version_number
4256: into l_object_version_number
4257: from per_periods_of_service pps,
4258: hr_pump_batch_line_user_keys key
4259: where key.user_key_value = p_person_user_key
4260: and pps.person_id = key.unique_key_id
4261: and pps.business_group_id = p_business_group_id

Line 4282: from per_periods_of_service pps,

4278: l_object_version_number number;
4279: begin
4280: select pps.object_version_number
4281: into l_object_version_number
4282: from per_periods_of_service pps,
4283: hr_pump_batch_line_user_keys key
4284: where key.user_key_value = p_person_user_key
4285: and pps.person_id = key.unique_key_id
4286: and pps.business_group_id = p_business_group_id

Line 4312: from per_periods_of_service pps,

4308: begin
4309:
4310: select pps.object_version_number
4311: into l_object_version_number
4312: from per_periods_of_service pps,
4313: hr_pump_batch_line_user_keys key
4314: where key.user_key_value = p_person_user_key
4315: and pps.person_id = key.unique_key_id
4316: and pps.business_group_id = p_business_group_id