DBA Data[Home] [Help]

APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PAY_PAYROLLS_F

Line 566: pay_payrolls_f ppf

562: --
563: select max(ppf.effective_end_date)
564: into l_virtual_date2
565: from per_assignments_f paf,
566: pay_payrolls_f ppf
567: where paf.assignment_id = p_assignment_id
568: and paf.payroll_id = ppf.payroll_id
569: and ppf.effective_end_date between
570: trunc(p_virtual_date, p_balance_time)

Line 2198: pay_payrolls_f ppf

2194: select min(paa.assignment_id)
2195: into l_assignment_id
2196: from pay_assignment_actions paa,
2197: pay_payroll_actions pact,
2198: pay_payrolls_f ppf
2199: where pact.effective_date <= p_virtual_date
2200: and pact.payroll_action_id=paa.payroll_action_id
2201: and pact.action_type in ('R', 'Q', 'I', 'V', 'B')
2202: and paa.tax_unit_id = p_gre_id_context