DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_ASSIGNMENTS_F

Line 3954: from per_assignments_f asg,

3950: l_ovn number;
3951: begin
3952: select asg.object_version_number
3953: into l_ovn
3954: from per_assignments_f asg,
3955: hr_pump_batch_line_user_keys key
3956: where key.user_key_value = p_assignment_user_key
3957: and asg.assignment_id = key.unique_key_id
3958: and p_effective_date between

Line 4578: per_assignments_f asg,

4574: begin
4575: select flv.lookup_code
4576: into l_code
4577: from fnd_lookup_values flv,
4578: per_assignments_f asg,
4579: hr_pump_batch_line_user_keys key
4580: where key.user_key_value = p_assignment_user_key
4581: and asg.assignment_id = key.unique_key_id
4582: and p_effective_date between