DBA Data[Home] [Help]

APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PAY_BASES

Line 306: from per_pay_bases ppb,

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,