Hi Gurus-
I have a requirement to divide a particular amount Monthly/Quarterly/Anually for some years based on the starting date.So i need the pl/sql logic to achieve this one.Please help me out & let me know if any questions.
Below is my example:
Let say amount=240,starting date=01-JAN-2013,term=Quarterly/Anually/Monthly, Years=5 Years (So now i need to calculate the amount for 5 years starting from 01-JAN-2013 to 31-DEC-2017 and the output should like below)
| Month | Monthly Amount | Quarterly Amount | Anually Amount |
| 1-Jan-13 | 20 | 60 | 240 |
| 1-Feb-13 | 20 |
| 1-Mar-13 | 20 |
| 1-Apr-13 | 20 | 60 |
| 1-May-13 | 20 |
| 1-Jun-13 | 20 |
| 1-Jul-13 | 20 | 60 |
| 1-Aug-13 | 20 |
| 1-Sep-13 | 20 |
| 1-Oct-13 | 20 | 60 |
| 1-Nov-13 | 20 |
| 1-Dec-13 | 20 |
| 1-Jan-14 | 20 | 60 | 240 |
| 1-Feb-14 | 20 |
| 1-Mar-14 | 20 |
| 1-Apr-14 | 20 | 60 |
| 1-May-14 | 20 |
| 1-Jun-14 | 20 |
| 1-Jul-14 | 20 | 60 |
| 1-Aug-14 | 20 |
| 1-Sep-14 | 20 |
| 1-Oct-14 | 20 | 60 |
| 1-Nov-14 | 20 |
| 1-Dec-14 | 20 |
Thanks a lot !!!!