[Home] [Help]
1893: is
1894: select fnd_date.date_to_canonical(min(prb.effective_date)) date_from,
1895: fnd_date.date_to_canonical(max(prb.effective_date)) date_to,
1896: sum(decode(ppa.action_type,'V',-1,1)) no_of_times
1897: from pay_run_balances prb,
1898: pay_assignment_actions ASSACT,
1899: pay_payroll_actions PACT,
1900: per_assignments_f ass,
1901: pay_payroll_actions ppa,