DBA Data[Home] [Help]

APPS.PAY_MX_DIM_MAG dependencies on FND_NUMBER

Line 565: ,to_char(FND_NUMBER.canonical_to_number(nvl(TAX_SUBSIDY_PCT,'0')), p_format)

561: ,decode(ANNUAL_TAX_CALC_FLAG, 'Y', '1',
562: 'N', '2' , '0') ANNUAL_TAX_CALC_FLAG
563: ,RATE_FISCAL_YEAR_IND
564: ,RATE_1991_IND
565: ,to_char(FND_NUMBER.canonical_to_number(nvl(TAX_SUBSIDY_PCT,'0')), p_format)
566: TAX_SUBSIDY_PCT
567: ,decode(UNION_WORKER_FLAG, 'Y', 1, 'N', 2, 0) UNION_WORKER_FLAG
568: ,0 ASSIMILATED_TO_SALARY_IND
569: ,STATE_ID

Line 688: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I

684: ,ISR_ON_CUMULATIVE_EARNINGS
685: ,ISR_ON_NON_CUMULATIVE_EARNINGS
686: ,0 ISR_SUBSIDY_EMPT_PAID_TO_EMP
687: ,0 ISR_SUBSIDY_INC_PAID_EMP
688: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
689: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
691: TAX_SUBSIDY_PCT_D
692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)

Line 689: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-

685: ,ISR_ON_NON_CUMULATIVE_EARNINGS
686: ,0 ISR_SUBSIDY_EMPT_PAID_TO_EMP
687: ,0 ISR_SUBSIDY_INC_PAID_EMP
688: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
689: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
691: TAX_SUBSIDY_PCT_D
692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
693: SUBSIDY_PORTION_APPLIED

Line 690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)

686: ,0 ISR_SUBSIDY_EMPT_PAID_TO_EMP
687: ,0 ISR_SUBSIDY_INC_PAID_EMP
688: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
689: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
691: TAX_SUBSIDY_PCT_D
692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
693: SUBSIDY_PORTION_APPLIED
694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)

Line 692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)

688: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
689: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
691: TAX_SUBSIDY_PCT_D
692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
693: SUBSIDY_PORTION_APPLIED
694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
695: SUBSIDY_PORTION_APPLIED_I
696: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-

Line 694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)

690: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
691: TAX_SUBSIDY_PCT_D
692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
693: SUBSIDY_PORTION_APPLIED
694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
695: SUBSIDY_PORTION_APPLIED_I
696: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
697: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
698: SUBSIDY_PORTION_APPLIED_D

Line 696: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-

692: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
693: SUBSIDY_PORTION_APPLIED
694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
695: SUBSIDY_PORTION_APPLIED_I
696: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
697: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
698: SUBSIDY_PORTION_APPLIED_D
699: ,TOT_EARNING_ASSI_CONCEPTS
700: ,EMPLOYEE_STATE_TAX_WITHHELD

Line 697: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)

693: SUBSIDY_PORTION_APPLIED
694: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
695: SUBSIDY_PORTION_APPLIED_I
696: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
697: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
698: SUBSIDY_PORTION_APPLIED_D
699: ,TOT_EARNING_ASSI_CONCEPTS
700: ,EMPLOYEE_STATE_TAX_WITHHELD
701: ,TOT_EXEMPT_EARNINGS