DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASSIGNMENTS_F

Line 3927: from per_assignments_f asg,

3923: l_ovn number;
3924: begin
3925: select asg.object_version_number
3926: into l_ovn
3927: from per_assignments_f asg,
3928: hr_pump_batch_line_user_keys key
3929: where key.user_key_value = p_assignment_user_key
3930: and asg.assignment_id = key.unique_key_id
3931: and p_effective_date between

Line 4551: per_assignments_f asg,

4547: begin
4548: select flv.lookup_code
4549: into l_code
4550: from fnd_lookup_values flv,
4551: per_assignments_f asg,
4552: hr_pump_batch_line_user_keys key
4553: where key.user_key_value = p_assignment_user_key
4554: and asg.assignment_id = key.unique_key_id
4555: and p_effective_date between