3560: c_basis_end date) is
3561:
3562: select pst.name
3563: from per_assignments_f assign,
3564: hr_all_positions_f_tl pst,
3565: hr_all_positions_f pos,
3566: hr_soft_coding_keyflex hsc
3567: where assign.person_id = c_person_id
3568: and assign.assignment_id = c_assignment_id
3631: 'SEGMENT30',ppd.segment30)
3632: from per_assignments_f assign,
3633: hr_soft_coding_keyflex hsc,
3634: hr_all_positions_f pos,
3635: hr_all_positions_f_tl pst,
3636: per_position_definitions ppd,
3637: hr_organization_units hou,
3638: hr_organization_information hoi,
3639: fnd_id_flex_segments fifs,