APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PAY_PROPOSALS_V2

Line 363: per_pay_proposals_v2 pppv,

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,
365: hr_lookups hrl
366: where paf.pay_basis_id = ppb.pay_basis_id and
367: paf.person_id=ppf.person_id and

Line 397: from per_pay_proposals_v2 pppv2

393: and ppf1.business_group_id = p_business_group_id
394: and ppf1.current_emp_or_apl_flag = 'Y'
395: ) and
396: pppv.change_date = (select max(pppv2.change_date)
397: from per_pay_proposals_v2 pppv2
398: where pppv2.assignment_id = paf.assignment_id
399: and paf.effective_end_date >= v_year_start --added for bug 12587192
400: and pppv2.change_date <= v_year_end
401: and pppv2.approved = 'Y'

Line 457: from per_pay_proposals_v2 ppp,

453: p_start_date date,
454: p_end_date date) is
455: select distinct ppp.assignment_id asg_id,
456: TRUNC(ppp.change_date) promo_date
457: from per_pay_proposals_v2 ppp,
458: per_all_people_f ppf,
459: per_all_assignments_f paf
460: where ppf.person_id = paf.person_id and
461: ppf.person_id = p_person_id and