DBA Data[Home] [Help]

APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PAY_BASES

Line 360: from per_pay_bases ppb,

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,