356: for the assignment */
357: cursor c_total_salary (p_person_id number) is
358: --select sum(trunc(to_number(pppv.proposed_salary)) * ppb.pay_annualization_factor) salary
359: select round(sum(to_number(pppv.proposed_salary) * ppb.pay_annualization_factor)) salary
360: from per_pay_bases ppb,
361: per_all_assignments_f paf,
362: per_all_people_f ppf,
363: per_pay_proposals_v2 pppv,
364: per_assignment_status_types past,