[Home] [Help]
3400:
3401: /* retrieve the accounting period ID */
3402: SELECT acct_period_id
3403: INTO l_inv_trx.acct_period_id
3404: FROM org_acct_periods
3405: WHERE organization_id = p_rcv_accttxn.organization_id
3406: AND l_le_txn_date BETWEEN period_start_date AND schedule_close_date
3407: AND open_flag = 'Y';
3408: