APPS.PSP_GENERAL dependencies on PER_PAY_PROPOSALS

Line 260: from per_pay_proposals ppp,

256: /***** Modified teh following cursor for R12 peformance fixes (bug 4507892)
257: CURSOR get_salary is
258: select ppp.proposed_salary,
259: ppb.pay_basis
260: from per_pay_proposals ppp,
261: per_assignments_f paf,
262: per_pay_bases ppb
263: where paf.assignment_id = p_assignment_id and
264: ppp.assignment_id = paf.assignment_id and

Line 267: ppp.change_date = (select max(change_date) from per_pay_proposals ppp1

263: where paf.assignment_id = p_assignment_id and
264: ppp.assignment_id = paf.assignment_id and
265: paf.pay_basis_id = ppb.pay_basis_id and
266: ppb.pay_basis in ('ANNUAL', 'MONTHLY') and
267: ppp.change_date = (select max(change_date) from per_pay_proposals ppp1
268: where ppp1.assignment_id = paf.assignment_id and
269: ppp1.approved = 'Y' and ppp1.change_date <= p_session_date);
270: End of comment for R12 performance fixes (bug 4507892) *****/
271:

Line 276: FROM per_pay_proposals ppp,

272: -- New cursor definition for bug fix 4507892
273: CURSOR get_salary IS
274: SELECT ppp.proposed_salary,
275: ppb.pay_basis
276: FROM per_pay_proposals ppp,
277: per_assignments_f paf,
278: per_pay_bases ppb
279: WHERE paf.assignment_id = p_assignment_id
280: AND ppp.assignment_id = paf.assignment_id

Line 284: FROM per_pay_proposals ppp1

280: AND ppp.assignment_id = paf.assignment_id
281: AND paf.pay_basis_id = ppb.pay_basis_id
282: AND ppb.pay_basis IN ('ANNUAL', 'MONTHLY')
283: AND ppp.change_date = (SELECT MAX(change_date)
284: FROM per_pay_proposals ppp1
285: WHERE ppp1.assignment_id = p_assignment_id
286: AND ppp1.approved = 'Y'
287: AND ppp1.change_date <= p_session_date);
288: