372: IS
373: --
374: CURSOR csr_get_asg_dates IS
375: SELECT effective_start_date, effective_end_date
376: FROM per_all_assignments_f
377: WHERE assignment_id = p_assignment_id
378: AND p_effective_date BETWEEN
379: effective_start_date and effective_end_date;
380: --
495: WHERE payroll_run_id = p_payroll_run_id;
496: --
497: CURSOR csr_get_assignment_bg IS
498: SELECT business_group_id
499: FROM per_all_assignments_f
500: WHERE assignment_id = p_assignment_id
501: AND p_effective_date BETWEEN
502: effective_start_date AND effective_end_date;
503: --