250: cursor csr_assignment_details
251: (p_assignment_id number
252: ,p_effective_date date) is
253: select *
254: from per_all_assignments_f
255: where assignment_id=p_assignment_id
256: and p_effective_date between effective_start_date and effective_end_date;
257: --
258: cursor csr_asg_status
476: app_rec per_applications%rowtype;
477: pds_rec per_periods_of_service%rowtype;
478: pdp_rec per_periods_of_placement%rowtype;
479: addr_rec per_addresses%rowtype;
480: asg_rec per_all_assignments_f%rowtype;
481: pgp_rec pay_people_groups%rowtype;
482: scl_rec hr_soft_coding_keyflex%rowtype;
483: pyp_rec per_pay_proposals%rowtype;
484: dpf_rec per_deployment_factors%rowtype;