DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on DUAL

Line 4774: FROM DUAL;

4770: --Find out the number of days the next month of the transaction date
4771: SELECT to_number(to_char(LAST_DAY(add_months(l_transaction_date,1)),'DD'))
4772: INTO
4773: l_no_days
4774: FROM DUAL;
4775:
4776: -- If the pending invoice days is greater than the # of days in the month,
4777: -- then pending_invoice_days is the # of days in the month.
4778: IF l_no_days < NVL(l_stat_typ_transaction.pending_invoice_days,15)