[Home] [Help]
302: /* Bug 4500929 fix : Modified the query for checking the maximum effective start date
303: for the assignment */
304: cursor c_total_salary (p_person_id number) is
305: select sum(trunc(to_number(pppv.proposed_salary)) * ppb.pay_annualization_factor) salary
306: from per_pay_bases ppb,
307: per_all_assignments_f paf,
308: per_all_people_f ppf,
309: per_pay_proposals_v2 pppv,
310: per_assignment_status_types past,