283: where recruitment_activity_id=p_recruitment_activity_id;
284: --
285: cursor csr_pgp_rec
286: (p_people_group_id number) is
287: select * from pay_people_groups
288: where people_group_id=p_people_group_id;
289: --
290: cursor csr_scl_rec
291: (p_soft_coding_keyflex_id number) is
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;
485: chk_rec per_checklist_items%rowtype;