[Home] [Help]
16955: FUNCTION next_val(p_num IN NUMBER)
16956: RETURN NUMBER
16957: IS
16958: CURSOR c IS
16959: SELECT ar_cash_basis_distributions_s.NEXTVAL
16960: FROM DUAL;
16961: l_num NUMBER;
16962: BEGIN
16963: OPEN c;
17046: , LEDGER_ID
17047: , BASE_CURRENCY
17048: )
17049: SELECT
17050: AR_CASH_BASIS_DISTRIBUTIONS_S.NEXTVAL -- cash_basis_distribution_id
17051: , lad.CREATED_BY -- created_by
17052: , lad.CREATION_DATE -- creation_date
17053: , lad.LAST_UPDATE_DATE -- last_update_date
17054: , lad.LAST_UPDATED_BY -- last_updated_by