APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PAY_PROPOSALS_V2

Line 309: per_pay_proposals_v2 pppv,

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,
311: hr_lookups hrl
312: where paf.pay_basis_id = ppb.pay_basis_id and
313: paf.person_id=ppf.person_id and

Line 342: from per_pay_proposals_v2 pppv2

338: and ppf1.business_group_id = p_business_group_id
339: and ppf1.current_emp_or_apl_flag = 'Y'
340: ) and
341: pppv.change_date = (select max(pppv2.change_date)
342: from per_pay_proposals_v2 pppv2
343: where pppv2.assignment_id = paf.assignment_id
344: and pppv2.change_date <= v_year_end
345: )
346: group by ppf.person_id;

Line 400: from per_pay_proposals_v2 ppp,

396: p_start_date date,
397: p_end_date date) is
398: select distinct ppp.assignment_id asg_id,
399: TRUNC(ppp.change_date) promo_date
400: from per_pay_proposals_v2 ppp,
401: per_all_people_f ppf,
402: per_all_assignments_f paf
403: where ppf.person_id = paf.person_id and
404: ppf.person_id = p_person_id and