DBA Data[Home] [Help]

APPS.PER_PDP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 254: from per_all_assignments_f asg

250: --
251: cursor csr_get_max_asg_start_date is
252: select min(asg.effective_start_date)
253: ,assignment_id
254: from per_all_assignments_f asg
255: where asg.period_of_placement_date_start = p_date_start
256: and asg.person_id = p_person_id
257: group by asg.assignment_id
258: order by 1 desc;