APPS.HR_PUMP_GET dependencies on PER_PERIODS_OF_SERVICE

Line 3520: from per_periods_of_service pps,

3516: l_period_of_service_id number;
3517: begin
3518: select pps.period_of_service_id
3519: into l_period_of_service_id
3520: from per_periods_of_service pps,
3521: hr_pump_batch_line_user_keys key
3522: where key.user_key_value = p_person_user_key
3523: and pps.person_id = key.unique_key_id
3524: and pps.business_group_id = p_business_group_id

Line 3545: from per_periods_of_service pps,

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

Line 3575: from per_periods_of_service pps,

3571: begin
3572:
3573: select pps.period_of_service_id
3574: into l_period_of_service_id
3575: from per_periods_of_service pps,
3576: hr_pump_batch_line_user_keys key
3577: where key.user_key_value = p_person_user_key
3578: and pps.person_id = key.unique_key_id
3579: and pps.business_group_id = p_business_group_id

Line 4230: from per_periods_of_service pps,

4226: l_object_version_number number;
4227: begin
4228: select pps.object_version_number
4229: into l_object_version_number
4230: from per_periods_of_service pps,
4231: hr_pump_batch_line_user_keys key
4232: where key.user_key_value = p_person_user_key
4233: and pps.person_id = key.unique_key_id
4234: and pps.business_group_id = p_business_group_id

Line 4255: from per_periods_of_service pps,

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

Line 4285: from per_periods_of_service pps,

4281: begin
4282:
4283: select pps.object_version_number
4284: into l_object_version_number
4285: from per_periods_of_service pps,
4286: hr_pump_batch_line_user_keys key
4287: where key.user_key_value = p_person_user_key
4288: and pps.person_id = key.unique_key_id
4289: and pps.business_group_id = p_business_group_id