918: cursor csr_job is
919: select pay_get_job_segment_pkg.get_job_segment(paa.business_group_id,job.job_definition_id,act.payroll_action_id) job
920: from pay_assignment_actions act,
921: per_assignments_f paa,
922: per_jobs job
923: where act.assignment_action_id = p_assactid
924: and act.assignment_id = paa.assignment_id
925: and paa.job_id = job.job_id(+)
926: and p_effective_date between paa.effective_start_date and paa.effective_end_date;