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_NL_TAXOFFICE_ARCHIVE dependencies on STANDARD

Line 503: input value Tax Code on the element Standard Tax Deduction.

499:
500:
501: /* fetching the Wage Tax Table Code for the given assignment in the tax year
502: This is basically the tax code.It is obtained from the run results for the
503: input value Tax Code on the element Standard Tax Deduction.
504: If there is a change during the year, then the code that has been set
505: for the longest time during the year is shown.*/
506:
507: l_Wage_Tax_Table_Code:=PAY_NL_TAXOFFICE_ARCHIVE.get_wage_tax_table_code(l_assignment_id,l_tax_year_start_date,l_tax_year_end_date);

Line 833: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');

829: l_retro_pre_tax_ded:=0;
830: l_context_id:=get_context_id('SOURCE_TEXT');
831:
832:
833: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');
834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
835: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
836:
837: if g_debug then

Line 838: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);

834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
835: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
836:
837: if g_debug then
838: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
839: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
840: hr_utility.set_location('l_balance_value'||l_balance_value,425);
841: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
842: end if;

Line 855: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');

851: hr_utility.set_location('l_balance_value'||l_balance_value,425);
852: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
853: end if;
854:
855: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');
856: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
857: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
858:
859: if g_debug then

Line 860: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);

856: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
857: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
858:
859: if g_debug then
860: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
861: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
862: hr_utility.set_location('l_balance_value'||l_balance_value,425);
863: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
864: end if;

Line 877: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');

873: hr_utility.set_location('l_balance_value'||l_balance_value,425);
874: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
875: end if;
876:
877: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');
878: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
879: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
880:
881: if g_debug then

Line 882: hr_utility.set_location('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);

878: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
879: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
880:
881: if g_debug then
882: hr_utility.set_location('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);
883: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
884: hr_utility.set_location('l_balance_value'||l_balance_value,425);
885: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
886: end if;

Line 900: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');

896: hr_utility.set_location('l_balance_value'||l_balance_value,425);
897: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
898: end if;
899:
900: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');
901: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
902: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
903:
904:

Line 906: hr_utility.set_location('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD',425);

902: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
903:
904:
905: if g_debug then
906: hr_utility.set_location('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD',425);
907: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
908: hr_utility.set_location('l_balance_value'||l_balance_value,425);
909: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
910: end if;

Line 926: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');

922: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
923: end if;
924:
925:
926: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');
927: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
928: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
929:
930: if g_debug then

Line 931: hr_utility.set_location('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);

927: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
928: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
929:
930: if g_debug then
931: hr_utility.set_location('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
932: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
933: hr_utility.set_location('l_balance_value'||l_balance_value,425);
934: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
935: end if;

Line 951: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');

947: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
948: end if;
949:
950:
951: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');
952: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
953: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
954:
955:

Line 957: hr_utility.set_location('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);

953: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
954:
955:
956: if g_debug then
957: hr_utility.set_location('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);
958: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
959: hr_utility.set_location('l_balance_value'||l_balance_value,425);
960: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
961: end if;

Line 975: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

971: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
972: end if;
973:
974:
975: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
976: IF l_context_id IS NULL then
977: l_balance_value:=0;
978: ELSE
979: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 984: hr_utility.set_location('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

980: END IF;
981: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
982:
983: if g_debug then
984: hr_utility.set_location('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
985: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
986: hr_utility.set_location('l_balance_value'||l_balance_value,425);
987: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
988: end if;

Line 1008: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

1004: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1005: end if;
1006:
1007:
1008: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1009: IF l_context_id IS NULL then
1010: l_balance_value:=0;
1011: ELSE
1012: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 1017: hr_utility.set_location('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

1013: END IF;
1014: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1015:
1016: if g_debug then
1017: hr_utility.set_location('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1018: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1019: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1020: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1021: end if;

Line 1063: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1059: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1060: end if;
1061:
1062:
1063: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1064: IF l_context_id IS NULL then
1065: l_balance_value:=0;
1066: ELSE
1067: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

Line 1071: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1067: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1068: END IF;
1069: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1070:
1071: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1072: IF l_context_id IS NULL then
1073: l_balance_value:=0;
1074: ELSE
1075: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

Line 1081: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1077: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1078:
1079:
1080: if g_debug then
1081: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1082: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1083: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1084: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1085: end if;

Line 1114: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1110: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1111: end if;
1112:
1113:
1114: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1115: IF l_context_id IS NULL then
1116: l_balance_value:=0;
1117: ELSE
1118: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

Line 1122: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1118: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1119: END IF;
1120: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1121:
1122: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1123: IF l_context_id IS NULL then
1124: l_balance_value:=0;
1125: ELSE
1126: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

Line 1133: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1129:
1130:
1131:
1132: if g_debug then
1133: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1134: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1135: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1136: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1137: end if;

Line 1196: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_REDUCTION_ASG_YTD');

1192: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1193: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1194: end if;
1195:
1196: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_REDUCTION_ASG_YTD');
1197: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1198: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1199:
1200: if g_debug then

Line 1201: hr_utility.set_location('STANDARD_TAX_REDUCTION_ASG_YTD',425);

1197: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1198: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1199:
1200: if g_debug then
1201: hr_utility.set_location('STANDARD_TAX_REDUCTION_ASG_YTD',425);
1202: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1203: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1204: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1205: end if;

Line 1218: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD');

1214: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1215: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1216: end if;
1217:
1218: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD');
1219: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1220: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1221:
1222: if g_debug then

Line 1223: hr_utility.set_location('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD',425);

1219: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1220: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1221:
1222: if g_debug then
1223: hr_utility.set_location('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD',425);
1224: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1225: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1226: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1227: end if;

Line 1274: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');

1270:
1271: l_sum_of_balances:=0;
1272:
1273:
1274: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
1275: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1276: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1277:
1278: if g_debug then

Line 1279: hr_utility.set_location('STANDARD_TAXABLE_INCOME_ASG_YTD',425);

1275: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1276: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1277:
1278: if g_debug then
1279: hr_utility.set_location('STANDARD_TAXABLE_INCOME_ASG_YTD',425);
1280: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1281: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1282: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1283: end if;

Line 1298: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');

1294: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1295: end if;
1296:
1297:
1298: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD');
1299: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1300: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1301:
1302: if g_debug then

Line 1303: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD',425);

1299: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1300: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1301:
1302: if g_debug then
1303: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD',425);
1304: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1305: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1306: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1307: end if;

Line 1310: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');

1306: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1307: end if;
1308:
1309:
1310: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
1311: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1312: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1313:
1314: if g_debug then

Line 1315: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD',425);

1311: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1312: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1313:
1314: if g_debug then
1315: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD',425);
1316: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1317: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1318: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1319: end if;

Line 1364: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_DEDUCTION_ASG_YTD');

1360: end if;
1361:
1362: l_wt_and_ni_cont:=0;
1363:
1364: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_DEDUCTION_ASG_YTD');
1365: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1366: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1367:
1368:

Line 1370: hr_utility.set_location('STANDARD_TAX_DEDUCTION_ASG_YTD',425);

1366: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1367:
1368:
1369: if g_debug then
1370: hr_utility.set_location('STANDARD_TAX_DEDUCTION_ASG_YTD',425);
1371: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1372: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1373: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1374: end if;

Line 1390: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD');

1386: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1387: end if;
1388:
1389:
1390: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD');
1391: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1392: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1393:
1394:

Line 1396: hr_utility.set_location('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD',425);

1392: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1393:
1394:
1395: if g_debug then
1396: hr_utility.set_location('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD',425);
1397: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1398: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1399: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1400: end if;

Line 1416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_YTD');

1412: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1413: END IF;
1414:
1415:
1416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_YTD');
1417: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1418: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1419:
1420:

Line 1422: hr_utility.set_location('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_YTD',425);

1418: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1419:
1420:
1421: if g_debug then
1422: hr_utility.set_location('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_ASG_YTD',425);
1423: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1424: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1425: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1426: END IF;

Line 1429: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_CORRECTION_ASG_YTD');

1425: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1426: END IF;
1427:
1428:
1429: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_CORRECTION_ASG_YTD');
1430: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1431: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1432:
1433:

Line 1435: hr_utility.set_location('STANDARD_TAX_CORRECTION_ASG_YTD',425);

1431: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1432:
1433:
1434: if g_debug then
1435: hr_utility.set_location('STANDARD_TAX_CORRECTION_ASG_YTD',425);
1436: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1437: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1438: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1439: end if;

Line 1614: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

1610: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1611: end if;
1612:
1613:
1614: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1615: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1616: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1617:
1618:

Line 1620: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

1616: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1617:
1618:
1619: if g_debug then
1620: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1621: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1622: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1623: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1624: end if;

Line 1666: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

1662: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1663: end if;
1664:
1665:
1666: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1667: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1668: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1669:
1670:

Line 1672: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

1668: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1669:
1670:
1671: if g_debug then
1672: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1673: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1674: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1675: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1676: end if;

Line 1723: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1719: end if;
1720:
1721:
1722:
1723: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1724: IF l_context_id IS NULL then
1725: l_balance_value:=0;
1726: ELSE
1727: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1732: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1728: END IF;
1729: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1730:
1731: if g_debug then
1732: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1733: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1734: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1735: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1736: end if;

Line 1794: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1790: end if;
1791:
1792:
1793:
1794: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1795: IF l_context_id IS NULL then
1796: l_balance_value:=0;
1797: ELSE
1798: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1804: hr_utility.set_location('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1800: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1801:
1802:
1803: if g_debug then
1804: hr_utility.set_location('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1805: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1806: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1807: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1808: end if;

Line 1865: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1861:
1862:
1863:
1864:
1865: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1866: IF l_context_id IS NULL then
1867: l_balance_value:=0;
1868: ELSE
1869: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1875: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1871: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1872:
1873:
1874: if g_debug then
1875: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1876: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1877: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1878: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1879: end if;

Line 1935: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1931: end if;
1932:
1933:
1934:
1935: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1936: IF l_context_id IS NULL then
1937: l_balance_value:=0;
1938: ELSE
1939: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1945: hr_utility.set_location('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1941: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1942:
1943:
1944: if g_debug then
1945: hr_utility.set_location('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1946: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1947: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1948: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1949: end if;

Line 2056: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',csr_tax_year_assgn_act_id_rec.date_earned);

2052: --end if;
2053:
2054: /*for csr_tax_year_assgn_act_id_rec in csr_tax_year_assgn_act_id
2055: loop
2056: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',csr_tax_year_assgn_act_id_rec.date_earned);
2057: l_input_value_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Special Indicators',csr_tax_year_assgn_act_id_rec.date_earned);
2058:
2059: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2060: FETCH csr_run_result_id into l_run_result_id;

Line 2439: pet.element_name='Standard Tax Deduction' and

2435: pay_run_results prr,
2436: pay_run_result_values prrv,
2437: per_time_periods ptp
2438: where
2439: pet.element_name='Standard Tax Deduction' and
2440: pet.element_type_id=piv.element_type_id and
2441: piv.name='Tax Reduction Flag' and
2442: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and
2443: ppa.payroll_action_id=paa.payroll_action_id and

Line 2465: pet.element_name='Standard Tax Deduction' and

2461: pay_run_results prr,
2462: pay_run_result_values prrv,
2463: per_time_periods ptp
2464: where
2465: pet.element_name='Standard Tax Deduction' and
2466: pet.element_type_id=piv.element_type_id and
2467: piv.name='Tax Reduction Flag' and
2468: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and
2469: ppa.payroll_action_id=paa.payroll_action_id and

Line 2644: pet.element_name='Standard Tax Deduction' and

2640: pay_input_values_f piv,
2641: pay_run_results prr,
2642: pay_run_result_values prrv
2643: where
2644: pet.element_name='Standard Tax Deduction' and
2645: pet.element_type_id=piv.element_type_id and
2646: piv.name='Tax Code' and
2647: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and
2648: ppa.payroll_action_id=paa.payroll_action_id and

Line 2669: pet.element_name='Standard Tax Deduction' and

2665: pay_input_values_f piv,
2666: pay_run_results prr,
2667: pay_run_result_values prrv
2668: where
2669: pet.element_name='Standard Tax Deduction' and
2670: pet.element_type_id=piv.element_type_id and
2671: piv.name='Tax Code' and
2672: --ppa.business_group_id = p_bg_id and
2673: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and

Line 2873: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

2869: hr_utility.set_location('Entering get_IZA_contributions',1050);
2870:
2871: l_IZA_contributions:=0;
2872:
2873: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
2874: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2875: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2876:
2877: if g_debug then

Line 2878: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

2874: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2875: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2876:
2877: if g_debug then
2878: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
2879: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2880: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2881: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2882: end if;

Line 2897: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');

2893: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2894: end if;
2895:
2896:
2897: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
2898: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2899: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2900:
2901: if g_debug then

Line 2902: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

2898: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2899: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2900:
2901: if g_debug then
2902: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
2903: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2904: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2905: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2906: end if;

Line 2936: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_STANDARD_TAX_ASG_YTD');

2932: l_defined_balance_id number;
2933:
2934: BEGIN
2935:
2936: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_STANDARD_TAX_ASG_YTD');
2937: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2938: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2939:
2940: if g_debug then

Line 2941: hr_utility.set_location('ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);

2937: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2938: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2939:
2940: if g_debug then
2941: hr_utility.set_location('ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);
2942: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2943: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2944: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2945: end if;

Line 2958: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD');

2954: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2955: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2956: end if;
2957:
2958: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD');
2959: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2960: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2961:
2962: if g_debug then

Line 2963: hr_utility.set_location('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);

2959: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2960: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2961:
2962: if g_debug then
2963: hr_utility.set_location('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);
2964: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2965: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2966: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2967: end if;

Line 3020: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

3016: end if;
3017:
3018:
3019:
3020: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3021: IF l_context_id IS NULL then
3022: l_balance_value:=0;
3023: ELSE
3024: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 3029: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

3025: END IF;
3026: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3027:
3028: if g_debug then
3029: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
3030: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
3031: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3032: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3033: end if;

Line 3071: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

3067: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3068: end if;
3069:
3070:
3071: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3072: IF l_context_id IS NULL then
3073: l_balance_value:=0;
3074: ELSE
3075: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 3081: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

3077: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3078:
3079:
3080: if g_debug then
3081: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
3082: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
3083: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3084: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3085: end if;