APPS.BEN_EXT_PERSON dependencies on PER_PAY_PROPOSALS

Line 1332: per_pay_proposals b,

1328: --
1329: cursor c (l_person_id number ) is select
1330: a.pay_annualization_factor,b.proposed_salary_n
1331: from per_pay_bases a,
1332: per_pay_proposals b,
1333: per_all_assignments_f c
1334: where
1335: c.person_id = l_person_id and
1336: p_effective_date between c.effective_start_date and c.effective_end_date and

Line 1342: from per_pay_proposals d

1338: c.assignment_id = b.assignment_id and
1339: c.pay_basis_id = a.pay_basis_id
1340: and b.change_date =
1341: (select max(d.change_date)
1342: from per_pay_proposals d
1343: where d.assignment_id = c.assignment_id
1344: and d.change_date <= p_effective_date
1345: and approved = 'Y' )
1346: ;