DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on PER_PAY_BASES

Line 262: per_pay_bases ppb

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
265: paf.pay_basis_id = ppb.pay_basis_id and
266: ppb.pay_basis in ('ANNUAL', 'MONTHLY') and

Line 278: per_pay_bases ppb

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
281: AND paf.pay_basis_id = ppb.pay_basis_id
282: AND ppb.pay_basis IN ('ANNUAL', 'MONTHLY')