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