DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_ARCHIVE dependencies on PAY_RUN_BALANCES

Line 1908: from pay_run_balances prb,

1904: is
1905: select fnd_date.date_to_canonical(min(prb.effective_date)) date_from,
1906: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1907: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1908: from pay_run_balances prb,
1909: pay_assignment_actions ASSACT,
1910: pay_payroll_actions PACT,
1911: per_assignments_f ass,
1912: pay_payroll_actions ppa,