DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_PAYROLLS_F

Line 597: pay_payrolls_f ppf

593: --
594: select max(ppf.effective_end_date)
595: into l_virtual_date2
596: from per_assignments_f paf,
597: pay_payrolls_f ppf
598: where paf.assignment_id = p_assignment_id
599: and paf.payroll_id = ppf.payroll_id
600: and ppf.effective_end_date between
601: trunc(p_virtual_date, p_balance_time)

Line 2459: pay_payrolls_f ppf

2455: select min(paa.assignment_id)
2456: into l_assignment_id
2457: from pay_assignment_actions paa,
2458: pay_payroll_actions pact,
2459: pay_payrolls_f ppf
2460: where pact.effective_date <= p_virtual_date
2461: and pact.payroll_action_id=paa.payroll_action_id
2462: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')
2463: and paa.tax_unit_id = p_gre_id_context