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: --------------------------------------------------------------------------
1011: FUNCTION get_phf_si_rates (p_assignment_id IN NUMBER

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2633: SELECT fnd_number.canonical_to_number(global_value)

2629: RETURN VARCHAR2
2630: IS
2631: CURSOR c_get_global_value(p_global_name IN VARCHAR2)
2632: IS
2633: SELECT fnd_number.canonical_to_number(global_value)
2634: FROM ff_globals_f
2635: WHERE legislation_code= 'CN'
2636: AND global_name = p_global_name
2637: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;

Line 3275: SELECT fnd_number.canonical_to_number(global_value)

3271: IS
3272:
3273: CURSOR c_get_global_value(p_global_name IN VARCHAR2)
3274: IS
3275: SELECT fnd_number.canonical_to_number(global_value)
3276: FROM ff_globals_f
3277: WHERE legislation_code = 'CN'
3278: AND global_name = p_global_name
3279: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;