802: -- --------------------------------------------
803: INSERT_MISSING_RATES;
804:
805: OPEN Invalid_Rates;
806: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
807: 'FROM CURRENCY CONVERSION DATE COLLECTION STATUS');
808: loop
809: FETCH Invalid_Rates INTO my_rate_date, my_payment_currency,
810: my_collection_status;
808: loop
809: FETCH Invalid_Rates INTO my_rate_date, my_payment_currency,
810: my_collection_status;
811: exit when Invalid_Rates % NOTFOUND;
812: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, my_payment_currency ||
813: ' '|| my_rate_date ||
814: ' '|| my_collection_status);
815: end loop;
816: