DBA Data[Home] [Help]

APPS.INV_MGD_MVT_FIN_MDTR dependencies on DUAL

Line 3935: FROM DUAL;

3931: --Find out the number of days the next month of the transaction date
3932: SELECT to_number(to_char(LAST_DAY(add_months(l_transaction_date,1)),'DD'))
3933: INTO
3934: l_no_days
3935: FROM DUAL;
3936:
3937: -- If the pending invoice days is greater than the # of days in the month,
3938: -- then pending_invoice_days is the # of days in the month.
3939: IF l_no_days < NVL(l_stat_typ_transaction.pending_invoice_days,15)