APPS.ASO_TAX_INT dependencies on DUAL

Line 3600: FROM DUAL;

3596: END IF;
3597: /* This profile is obsoleted
3598: SELECT NVL(FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID'), 0)
3599: INTO l_cust_trx_type_id
3600: FROM DUAL;
3601: */
3602:
3603: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID', p_qte_line_rec.org_id), 0)
3604: INTO l_cust_trx_type_id FROM DUAL;

Line 3604: INTO l_cust_trx_type_id FROM DUAL;

3600: FROM DUAL;
3601: */
3602:
3603: SELECT NVL(oe_sys_parameters.value('OE_INVOICE_TRANSACTION_TYPE_ID', p_qte_line_rec.org_id), 0)
3604: INTO l_cust_trx_type_id FROM DUAL;
3605:
3606: END IF;
3607: END IF;
3608: RETURN(l_cust_trx_type_id);

Line 3653: FROM DUAL;

3649: END IF;
3650: IF l_inv_cust_trx_type_id = 0 OR l_cust_trx_type_id = 0 THEN
3651: SELECT NVL(FND_PROFILE.VALUE('OE_CREDIT_TRANSACTION_TYPE_ID'), 0)
3652: INTO l_cust_trx_type_id
3653: FROM DUAL;
3654:
3655: END IF;
3656: RETURN(l_cust_trx_type_id);
3657: END IF;