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_CN_DEDUCTIONS dependencies on FND_NUMBER

Line 773: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount

769: --
770: SELECT org_information4 -- EE Contribution Base
771: ,org_information5 -- ER Contribution Base
772: ,org_information6 -- Low Limit Method
773: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount
774: ,org_information8 -- High Limit Method
775: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
776: ,org_information10 -- Switch Period Periodicity
777: ,org_information11 -- Switch Period Month

Line 775: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount

771: ,org_information5 -- ER Contribution Base
772: ,org_information6 -- Low Limit Method
773: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount
774: ,org_information8 -- High Limit Method
775: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
776: ,org_information10 -- Switch Period Periodicity
777: ,org_information11 -- Switch Period Month
778: ,org_information12 -- Rounding Method
779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary

Line 779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary

775: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
776: ,org_information10 -- Switch Period Periodicity
777: ,org_information11 -- Switch Period Month
778: ,org_information12 -- Rounding Method
779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199

Line 780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary

776: ,org_information10 -- Switch Period Periodicity
777: ,org_information11 -- Switch Period Month
778: ,org_information12 -- Rounding Method
779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
784: FROM hr_organization_information

Line 781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount

777: ,org_information11 -- Switch Period Month
778: ,org_information12 -- Rounding Method
779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
784: FROM hr_organization_information
785: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'

Line 782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount

778: ,org_information12 -- Rounding Method
779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
784: FROM hr_organization_information
785: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
786: AND organization_id = p_business_group_id

Line 783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199

779: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
780: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
781: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
782: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
783: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
784: FROM hr_organization_information
785: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
786: AND organization_id = p_business_group_id
787: AND p_effective_date BETWEEN to_date(org_information15,'YYYY/MM/DD HH24:MI:SS')

Line 798: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount

794: --
795: SELECT org_information4 -- EE Contribution Base
796: ,org_information5 -- ER Contribution Base
797: ,org_information6 -- Low Limit Method
798: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount
799: ,org_information8 -- High Limit Method
800: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
801: ,org_information10 -- Switch Period Periodicity
802: ,org_information11 -- Switch Period Month

Line 800: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount

796: ,org_information5 -- ER Contribution Base
797: ,org_information6 -- Low Limit Method
798: ,fnd_number.canonical_to_number(org_information7) -- Low Limit Amount
799: ,org_information8 -- High Limit Method
800: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
801: ,org_information10 -- Switch Period Periodicity
802: ,org_information11 -- Switch Period Month
803: ,org_information12 -- Rounding Method
804: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary

Line 804: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary

800: ,fnd_number.canonical_to_number(org_information9) -- High Limit Amount
801: ,org_information10 -- Switch Period Periodicity
802: ,org_information11 -- Switch Period Month
803: ,org_information12 -- Rounding Method
804: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
805: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
806: --
807: -- Bug 3017511 changes. Added these two missed columns
808: --

Line 805: ,fnd_number.canonical_to_number(org_information14) -- Average Salary

801: ,org_information10 -- Switch Period Periodicity
802: ,org_information11 -- Switch Period Month
803: ,org_information12 -- Rounding Method
804: ,fnd_number.canonical_to_number(org_information13) -- Lowest Average Salary
805: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
806: --
807: -- Bug 3017511 changes. Added these two missed columns
808: --
809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount

Line 809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount

805: ,fnd_number.canonical_to_number(org_information14) -- Average Salary
806: --
807: -- Bug 3017511 changes. Added these two missed columns
808: --
809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
810: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
811: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
812: FROM hr_organization_information
813: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'

Line 810: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount

806: --
807: -- Bug 3017511 changes. Added these two missed columns
808: --
809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
810: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
811: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
812: FROM hr_organization_information
813: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
814: AND organization_id = p_business_group_id

Line 811: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199

807: -- Bug 3017511 changes. Added these two missed columns
808: --
809: ,fnd_number.canonical_to_number(org_information17) -- EE Fixed Amount
810: ,fnd_number.canonical_to_number(org_information18) -- ER Fixed Amount
811: ,fnd_number.canonical_to_number(org_information19) -- EE/ER Tax Threshold amount for bug 6828199
812: FROM hr_organization_information
813: WHERE org_information_context = 'PER_CONT_AREA_CONT_BASE_CN'
814: AND organization_id = p_business_group_id
815: AND p_effective_date BETWEEN to_date(org_information15,'YYYY/MM/DD HH24:MI:SS')

Line 1007: -- 2.1 27-May-08 dduvvuri Bug 7120765 - Added fnd_number.canonical_to_number

1003: -- methods support. --
1004: -- 1.9 14-Mar-08 dduvvuri Bug 6828199 - Modified the signature to access
1005: -- EE and ER Tax threshold rates
1006: -- 2.0 12-May-08 dduvvuri Bug 6943573 - Added cursor c_org4
1007: -- 2.1 27-May-08 dduvvuri Bug 7120765 - Added fnd_number.canonical_to_number
1008: -- to org_information13 and org_information14 in all
1009: -- the 4 cursors.
1010: -- 2.2 17-Aug-2011 prasrang Added code to handle the increase in --
1011: -- precision for EE Rate and ER Rate. --

Line 1044: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate

1040: --
1041:
1042: CURSOR c_org1
1043: IS
1044: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1045: ,org_information5 -- EE Percent or Fixed
1046: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1047: ,org_information7 -- EE Percent or Fixed
1048: ,org_information8 -- EE Rounding Method

Line 1046: ,fnd_number.canonical_to_number(org_information6) -- EE Rate

1042: CURSOR c_org1
1043: IS
1044: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1045: ,org_information5 -- EE Percent or Fixed
1046: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1047: ,org_information7 -- EE Percent or Fixed
1048: ,org_information8 -- EE Rounding Method
1049: ,org_information12 -- ER Rounding Method
1050: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

Line 1050: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

1046: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1047: ,org_information7 -- EE Percent or Fixed
1048: ,org_information8 -- EE Rounding Method
1049: ,org_information12 -- ER Rounding Method
1050: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1051: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1052: FROM hr_organization_information
1053: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1054: AND organization_id = p_business_group_id

Line 1051: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199

1047: ,org_information7 -- EE Percent or Fixed
1048: ,org_information8 -- EE Rounding Method
1049: ,org_information12 -- ER Rounding Method
1050: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1051: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1052: FROM hr_organization_information
1053: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1054: AND organization_id = p_business_group_id
1055: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')

Line 1064: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate

1060: AND org_information9 = p_hukou_type;
1061:
1062: CURSOR c_org2
1063: IS
1064: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1065: ,org_information5 -- EE Percent or Fixed
1066: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1067: ,org_information7 -- EE Percent or Fixed
1068: ,org_information8 -- EE Rounding Method

Line 1066: ,fnd_number.canonical_to_number(org_information6) -- EE Rate

1062: CURSOR c_org2
1063: IS
1064: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1065: ,org_information5 -- EE Percent or Fixed
1066: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1067: ,org_information7 -- EE Percent or Fixed
1068: ,org_information8 -- EE Rounding Method
1069: ,org_information12 -- ER Rounding Method
1070: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

Line 1070: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

1066: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1067: ,org_information7 -- EE Percent or Fixed
1068: ,org_information8 -- EE Rounding Method
1069: ,org_information12 -- ER Rounding Method
1070: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1071: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1072: FROM hr_organization_information
1073: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1074: AND organization_id = p_business_group_id

Line 1071: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199

1067: ,org_information7 -- EE Percent or Fixed
1068: ,org_information8 -- EE Rounding Method
1069: ,org_information12 -- ER Rounding Method
1070: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1071: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1072: FROM hr_organization_information
1073: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1074: AND organization_id = p_business_group_id
1075: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')

Line 1084: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate

1080: AND org_information9 IS NULL;
1081:
1082: CURSOR c_org3
1083: IS
1084: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1085: ,org_information5 -- EE Percent or Fixed
1086: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1087: ,org_information7 -- EE Percent or Fixed
1088: ,org_information8 -- EE Rounding Method

Line 1086: ,fnd_number.canonical_to_number(org_information6) -- EE Rate

1082: CURSOR c_org3
1083: IS
1084: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1085: ,org_information5 -- EE Percent or Fixed
1086: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1087: ,org_information7 -- EE Percent or Fixed
1088: ,org_information8 -- EE Rounding Method
1089: ,org_information12 -- ER Rounding Method
1090: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

Line 1090: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

1086: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1087: ,org_information7 -- EE Percent or Fixed
1088: ,org_information8 -- EE Rounding Method
1089: ,org_information12 -- ER Rounding Method
1090: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1091: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1092: FROM hr_organization_information
1093: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1094: AND organization_id = p_business_group_id

Line 1091: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199

1087: ,org_information7 -- EE Percent or Fixed
1088: ,org_information8 -- EE Rounding Method
1089: ,org_information12 -- ER Rounding Method
1090: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1091: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1092: FROM hr_organization_information
1093: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1094: AND organization_id = p_business_group_id
1095: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')

Line 1104: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate

1100: AND org_information9 IS NULL;
1101:
1102: CURSOR c_org4
1103: IS
1104: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1105: ,org_information5 -- EE Percent or Fixed
1106: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1107: ,org_information7 -- EE Percent or Fixed
1108: ,org_information8 -- EE Rounding Method

Line 1106: ,fnd_number.canonical_to_number(org_information6) -- EE Rate

1102: CURSOR c_org4
1103: IS
1104: SELECT fnd_number.canonical_to_number(org_information4) -- EE Rate
1105: ,org_information5 -- EE Percent or Fixed
1106: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1107: ,org_information7 -- EE Percent or Fixed
1108: ,org_information8 -- EE Rounding Method
1109: ,org_information12 -- ER Rounding Method
1110: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

Line 1110: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199

1106: ,fnd_number.canonical_to_number(org_information6) -- EE Rate
1107: ,org_information7 -- EE Percent or Fixed
1108: ,org_information8 -- EE Rounding Method
1109: ,org_information12 -- ER Rounding Method
1110: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1111: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1112: FROM hr_organization_information
1113: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1114: AND organization_id = p_business_group_id

Line 1111: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199

1107: ,org_information7 -- EE Percent or Fixed
1108: ,org_information8 -- EE Rounding Method
1109: ,org_information12 -- ER Rounding Method
1110: ,fnd_number.canonical_to_number(org_information13) -- EE Tax Threshold rate for bug 6828199
1111: ,fnd_number.canonical_to_number(org_information14) -- ER Tax thershold rate for bug 6828199
1112: FROM hr_organization_information
1113: WHERE org_information_context = 'PER_CONT_AREA_PHF_SI_RATES_CN'
1114: AND organization_id = p_business_group_id
1115: AND p_effective_date BETWEEN to_date(org_information10,'YYYY/MM/DD HH24:MI:SS')

Line 1149: SELECT fnd_number.canonical_to_number(round(months_between(c_effective_date,min(effective_start_date))/12,2)) mths_of_service

1145: -- cursor from csr_months_of_service to csr_years_of_service
1146: --
1147: CURSOR csr_years_of_service(c_effective_date DATE, c_assignment_id NUMBER)
1148: IS
1149: SELECT fnd_number.canonical_to_number(round(months_between(c_effective_date,min(effective_start_date))/12,2)) mths_of_service
1150: FROM per_all_assignments_f
1151: WHERE assignment_id = c_assignment_id; --
1152: -- Cursor to find number of column instances of user table
1153: --

Line 1222: l_er_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

1218: hr_cn_api.set_location(g_debug,' Employer rate specified in UT, Num of records '|| l_count_ut, 13);
1219:
1220: IF l_count_ut > 0 THEN
1221: -- Fetch Employer Contribution Rate
1222: l_er_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value
1223: (p_business_group_id => p_business_group_id
1224: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1225: ,p_column_name => 'Employer Rate'
1226: ,p_row_name => 'Employer Rate'

Line 1227: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)

1223: (p_business_group_id => p_business_group_id
1224: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1225: ,p_column_name => 'Employer Rate'
1226: ,p_row_name => 'Employer Rate'
1227: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)
1228: ,p_effective_date => p_effective_date
1229: ,p_message => l_ut_message));
1230:
1231: hr_cn_api.set_location(g_debug,' Employer rate '|| l_er_rate, 14);

Line 1250: l_ee_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value

1246: hr_cn_api.set_location(g_debug,' Employee rate specified in UT, Num of records '|| l_count_ut, 15);
1247:
1248: IF l_count_ut > 0 THEN
1249: -- Fetch Employee Contribution Rate
1250: l_ee_rate := fnd_number.canonical_to_number(hr_cn_api.get_user_table_value
1251: (p_business_group_id => p_business_group_id
1252: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1253: ,p_column_name => 'Employee Rate'
1254: ,p_row_name => 'Employee Rate'

Line 1255: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)

1251: (p_business_group_id => p_business_group_id
1252: ,p_table_name => 'China Enterprise Annuity Contribution Rate'
1253: ,p_column_name => 'Employee Rate'
1254: ,p_row_name => 'Employee Rate'
1255: ,p_row_value => fnd_number.number_to_canonical(l_yrs_of_srvc)
1256: ,p_effective_date => p_effective_date
1257: ,p_message => l_ut_message));
1258:
1259: hr_cn_api.set_location(g_debug,' Employee rate '|| l_ee_rate, 16);

Line 2647: SELECT fnd_number.canonical_to_number(global_value)

2643: RETURN VARCHAR2
2644: IS
2645: CURSOR c_get_global_value(p_global_name IN VARCHAR2)
2646: IS
2647: SELECT fnd_number.canonical_to_number(global_value)
2648: FROM ff_globals_f
2649: WHERE legislation_code= 'CN'
2650: AND global_name = p_global_name
2651: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;

Line 3322: SELECT fnd_number.canonical_to_number(global_value)

3318: IS
3319:
3320: CURSOR c_get_global_value(p_global_name IN VARCHAR2)
3321: IS
3322: SELECT fnd_number.canonical_to_number(global_value)
3323: FROM ff_globals_f
3324: WHERE legislation_code = 'CN'
3325: AND global_name = p_global_name
3326: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;

Line 4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(

4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);
4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(
4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));
4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);
4652: p_phf_si_earnings_pyear := p_phf_si_earnings_pyear / l_pay_runs_prev_yr ;
4653: END IF;