oracle enhancement
hi i have this forms program which i am using to generate an output but i have this problem my program is not as flexible as it is if given in the different scenario. for instance if there are multiple deductions the generated output only can provide data in which the reference are in line with it meaning the deductions which are not in line with the reference will not be included. it only works on one is to one with one reference and one deductions. any tips..
PROCEDURE collected IS
CURSOR C1 IS
SELECT ALL sum(rct.rct_amount) "TOTAL_AMOUNT"
PROCEDURE collected IS
CURSOR C1 IS
SELECT ALL sum(rct.rct_amount) "TOTAL_AMOUNT"
0