eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_DIM_MAG dependencies on FND_NUMBER

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

567: ,decode(ANNUAL_TAX_CALC_FLAG, 'Y', '1',
568: 'N', '2' , '2') ANNUAL_TAX_CALC_FLAG
569: ,1 RATE_FISCAL_YEAR_IND /*7702851*/
570: ,2 RATE_1991_IND
571: ,to_char(FND_NUMBER.canonical_to_number(nvl(TAX_SUBSIDY_PCT,'0')), p_format)
572: TAX_SUBSIDY_PCT
573: ,decode(UNION_WORKER_FLAG, 'Y', 1, 'N', 2, 0) UNION_WORKER_FLAG
574: ,'0' ASSIMILATED_TO_SALARY_IND
575: ,STATE_ID

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

697: ,ISR_ON_CUMULATIVE_EARNINGS
698: ,ISR_ON_NON_CUMULATIVE_EARNINGS
699: ,ISR_SUBSIDY_FOR_EMP ISR_SUBSIDY_EMPT_PAID_TO_EMP /*7702851*/
700: ,0 ISR_SUBSIDY_INC_PAID_EMP
701: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
702: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
703: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
704: TAX_SUBSIDY_PCT_D
705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)

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

698: ,ISR_ON_NON_CUMULATIVE_EARNINGS
699: ,ISR_SUBSIDY_FOR_EMP ISR_SUBSIDY_EMPT_PAID_TO_EMP /*7702851*/
700: ,0 ISR_SUBSIDY_INC_PAID_EMP
701: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
702: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
703: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
704: TAX_SUBSIDY_PCT_D
705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
706: SUBSIDY_PORTION_APPLIED

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

699: ,ISR_SUBSIDY_FOR_EMP ISR_SUBSIDY_EMPT_PAID_TO_EMP /*7702851*/
700: ,0 ISR_SUBSIDY_INC_PAID_EMP
701: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
702: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
703: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
704: TAX_SUBSIDY_PCT_D
705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
706: SUBSIDY_PORTION_APPLIED
707: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)

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

701: ,trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0) TAX_SUBSIDY_PCT_I
702: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0'))-
703: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
704: TAX_SUBSIDY_PCT_D
705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
706: SUBSIDY_PORTION_APPLIED
707: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
708: SUBSIDY_PORTION_APPLIED_I
709: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-

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

703: trunc(FND_NUMBER.canonical_to_number(NVL(tax_subsidy_pct,'0')),0),'.',''),4,0)
704: TAX_SUBSIDY_PCT_D
705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
706: SUBSIDY_PORTION_APPLIED
707: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
708: SUBSIDY_PORTION_APPLIED_I
709: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
710: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
711: SUBSIDY_PORTION_APPLIED_D

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

705: ,to_char(FND_NUMBER.canonical_to_number(nvl(SUBSIDY_PORTION_APPLIED,'0')),p_format)
706: SUBSIDY_PORTION_APPLIED
707: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
708: SUBSIDY_PORTION_APPLIED_I
709: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
710: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
711: SUBSIDY_PORTION_APPLIED_D
712: ,TOT_EARNING_ASSI_CONCEPTS
713: ,EMPLOYEE_STATE_TAX_WITHHELD

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

706: SUBSIDY_PORTION_APPLIED
707: ,trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0)
708: SUBSIDY_PORTION_APPLIED_I
709: ,rpad(replace(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0'))-
710: trunc(FND_NUMBER.canonical_to_number(NVL(subsidy_portion_applied,'0')),0),'.',''),4,0)
711: SUBSIDY_PORTION_APPLIED_D
712: ,TOT_EARNING_ASSI_CONCEPTS
713: ,EMPLOYEE_STATE_TAX_WITHHELD
714: ,TOT_EXEMPT_EARNINGS

Line 801: IF fnd_number.canonical_to_number(prev_dim.start_month) >

797: IF ln_person_id = -1 THEN
798: prev_dim := dim;
799: ELSE
800: prev_dim.REHIRE_FLAG :='Y';
801: IF fnd_number.canonical_to_number(prev_dim.start_month) >
802: fnd_number.canonical_to_number(dim.start_month) THEN
803: prev_dim.start_month := dim.start_month;
804: END IF;
805: IF fnd_number.canonical_to_number(prev_dim.end_month) <

Line 802: fnd_number.canonical_to_number(dim.start_month) THEN

798: prev_dim := dim;
799: ELSE
800: prev_dim.REHIRE_FLAG :='Y';
801: IF fnd_number.canonical_to_number(prev_dim.start_month) >
802: fnd_number.canonical_to_number(dim.start_month) THEN
803: prev_dim.start_month := dim.start_month;
804: END IF;
805: IF fnd_number.canonical_to_number(prev_dim.end_month) <
806: fnd_number.canonical_to_number(dim.end_month) THEN

Line 805: IF fnd_number.canonical_to_number(prev_dim.end_month) <

801: IF fnd_number.canonical_to_number(prev_dim.start_month) >
802: fnd_number.canonical_to_number(dim.start_month) THEN
803: prev_dim.start_month := dim.start_month;
804: END IF;
805: IF fnd_number.canonical_to_number(prev_dim.end_month) <
806: fnd_number.canonical_to_number(dim.end_month) THEN
807: prev_dim.end_month := dim.end_month;
808: END IF; /*7951969*/
809: prev_dim.RET_EARNINGS_IN_PART_PYMNT :=

Line 806: fnd_number.canonical_to_number(dim.end_month) THEN

802: fnd_number.canonical_to_number(dim.start_month) THEN
803: prev_dim.start_month := dim.start_month;
804: END IF;
805: IF fnd_number.canonical_to_number(prev_dim.end_month) <
806: fnd_number.canonical_to_number(dim.end_month) THEN
807: prev_dim.end_month := dim.end_month;
808: END IF; /*7951969*/
809: prev_dim.RET_EARNINGS_IN_PART_PYMNT :=
810: prev_dim.RET_EARNINGS_IN_PART_PYMNT +