DBA Data[Home] [Help]

APPS.JG_ZZ_JOURNAL_AP_PKG dependencies on FND_NUMBER

Line 596: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) TAXABLE_SEL_INV

592: ,NVL(JZVTD.taxable_amt,0) TAXABLE_AMOUNT
593: ,NVL(JZVTD.taxable_amt_funcl_curr,0) TAXABLE_BASE_AMOUNT
594: ,NVL(JZVTD.tax_amt,0) TAX_AMOUNT
595: ,NVL(JZVTD.tax_amt_funcl_curr,0) TAX_BASE_AMOUNT
596: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) TAXABLE_SEL_INV
597: ,JZVTD.offset_tax_rate_code OFFSET_TAX_CODE_ID
598: ,DECODE(JZVTD.tax_recoverable_flag ,'Y',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)) TAXABLE_REC_AMT
599: ,DECODE(JZVTD.tax_recoverable_flag ,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)) TAXABLE_NREC_AMT
600: ,DECODE(JZVTD.tax_recoverable_flag ,'Y',JZVTD.tax_amt) TAX_REC_AMT

Line 806: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) SEL_INV_AMOUNT

802: ,NVL(DECODE(tax_recoverable_flag,'N',taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_NREC_BASE_AMOUNT
803: ,NVL(DECODE(tax_recoverable_flag,'N',taxable_amt*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_NREC_AMOUNT
804: ,NVL(DECODE(tax_recoverable_flag,'N',tax_amt_funcl_curr),0) TAX_NREC_BASE_AMOUNT
805: ,NVL(DECODE(tax_recoverable_flag,'N',tax_amt) ,0) TAX_NREC_AMOUNT
806: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) SEL_INV_AMOUNT
807: ,JZVTD.tax_recovery_rate RECOVERY_RATE
808: ,DECODE(JZVTD.offset_tax_rate_code, NULL,NVL(tax_amt,0) + NVL(taxable_amt,0),NVL(DECODE(TAX_RECOVERABLE_FLAG ,'Y',TAXABLE_AMT),0) + NVL(DECODE(TAX_RECOVERABLE_FLAG ,'N',TAXABLE_AMT),0)) FOREIGN_AMT
809: ,JZVTD.tax_recoverable_flag TAX_RECOVERABLE_FLAG
810: -- ,DECODE(flv.tag, cp_tax_tag , '^', NULL) EXEMPT_FLAG