DBA Data[Home] [Help]

APPS.PER_SALADMIN_UTILITY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 445: from pay_assignment_actions paa,

441:
442: cursor csr_last_dt is
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