DBA Data[Home] [Help]

APPS.PAY_FF_FUNCTIONS dependencies on PER_PAY_PROPOSALS

Line 542: per_pay_proposals pro,

538: FROM per_people_f per,
539: per_time_period_types tpt,
540: per_assignments_f ass,
541: per_pay_bases ppb,
542: per_pay_proposals pro,
543: pay_all_payrolls_f prl
544: WHERE per.person_id = ass.person_id
545: AND ass.pay_basis_id = ppb.pay_basis_id
546: AND ass.assignment_type = 'E'

Line 553: FROM per_pay_proposals pro1

549: nvl(prl.effective_end_date, ass.effective_start_date)
550: AND prl.period_type = tpt.period_type
551: AND ass.assignment_id = pro.assignment_id(+)
552: AND pro.change_date = (SELECT MAX(change_date)
553: FROM per_pay_proposals pro1
554: WHERE pro.assignment_id = pro1.assignment_id
555: AND pro1.approved = 'Y'
556: AND pro1.change_date <= l_effective_date)
557: AND ass.business_group_ID + 0 = NVL(hr_general.get_business_group_id,