DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_PAYROLL_ACTIONS

Line 447: pay_payroll_actions ppa

443: ---removed nvl from query, now returns null when no payroll run bug#9612944
444: Select /*+ use_nl(paf paa) */ max(ppa.date_earned)
445: from pay_assignment_actions paa,
446: per_all_assignments_f paf,
447: pay_payroll_actions ppa
448: where paf.assignment_id = p_assignment_id
449: and (paf.effective_end_date >= l_asg_start_date
450: and paf.effective_start_date <= hr_general.end_of_time)
451: and paa.assignment_id = paf.assignment_id