116: END IF;
117:
118: IF x_payment_term_id Is NULL THEN
119: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Get the payment term id from hz_cust_accounts table');
121: END IF;
122: select payment_term_id into x_payment_term_id
123: from hz_cust_accounts
124: where CUST_ACCOUNT_ID = p_bill_to_customer_account_id;
119: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
120: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Get the payment term id from hz_cust_accounts table');
121: END IF;
122: select payment_term_id into x_payment_term_id
123: from hz_cust_accounts
124: where CUST_ACCOUNT_ID = p_bill_to_customer_account_id;
125: END IF;
126:
127: EXCEPTION