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 504: input value Tax Code on the element Standard Tax Deduction.

500:
501:
502: /* fetching the Wage Tax Table Code for the given assignment in the tax year
503: This is basically the tax code.It is obtained from the run results for the
504: input value Tax Code on the element Standard Tax Deduction.
505: If there is a change during the year, then the code that has been set
506: for the longest time during the year is shown.*/
507:
508: 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 846: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');

842: l_retro_pre_tax_ded:=0;
843: l_context_id:=get_context_id('SOURCE_TEXT');
844:
845:
846: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');
847: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
848: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
849:
850: if g_debug then

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

847: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
848: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
849:
850: if g_debug then
851: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);
852: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
853: hr_utility.set_location('l_balance_value'||l_balance_value,425);
854: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
855: end if;

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

864: hr_utility.set_location('l_balance_value'||l_balance_value,425);
865: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
866: end if;
867:
868: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');
869: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
870: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
871:
872: if g_debug then

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

869: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
870: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
871:
872: if g_debug then
873: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
874: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
875: hr_utility.set_location('l_balance_value'||l_balance_value,425);
876: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
877: end if;

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

886: hr_utility.set_location('l_balance_value'||l_balance_value,425);
887: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
888: end if;
889:
890: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');
891: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
892: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
893:
894: if g_debug then

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

891: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
892: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
893:
894: if g_debug then
895: hr_utility.set_location('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);
896: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
897: hr_utility.set_location('l_balance_value'||l_balance_value,425);
898: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
899: end if;

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

909: hr_utility.set_location('l_balance_value'||l_balance_value,425);
910: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
911: end if;
912:
913: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD');
914: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
915: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
916:
917:

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

915: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
916:
917:
918: if g_debug then
919: hr_utility.set_location('RETRO_SI_INCOME_STANDARD_TAX_ASG_YTD',425);
920: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
921: hr_utility.set_location('l_balance_value'||l_balance_value,425);
922: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
923: end if;

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

935: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
936: end if;
937:
938:
939: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD');
940: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
941: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
942:
943: if g_debug then

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

940: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
941: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
942:
943: if g_debug then
944: hr_utility.set_location('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);
945: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
946: hr_utility.set_location('l_balance_value'||l_balance_value,425);
947: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
948: end if;

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

960: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
961: end if;
962:
963:
964: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD');
965: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
966: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
967:
968:

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

966: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
967:
968:
969: if g_debug then
970: hr_utility.set_location('RETRO_WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);
971: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
972: hr_utility.set_location('l_balance_value'||l_balance_value,425);
973: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
974: end if;

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

984: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
985: end if;
986:
987:
988: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
989: IF l_context_id IS NULL then
990: l_balance_value:=0;
991: ELSE
992: 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 997: hr_utility.set_location('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

993: END IF;
994: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
995:
996: if g_debug then
997: hr_utility.set_location('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
998: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
999: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1000: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1001: end if;

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

1017: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1018: end if;
1019:
1020:
1021: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1022: IF l_context_id IS NULL then
1023: l_balance_value:=0;
1024: ELSE
1025: 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 1030: hr_utility.set_location('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

1026: END IF;
1027: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1028:
1029: if g_debug then
1030: hr_utility.set_location('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1031: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1032: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1033: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1034: end if;

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

1072: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1073: end if;
1074:
1075:
1076: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1077: IF l_context_id IS NULL then
1078: l_balance_value:=0;
1079: ELSE
1080: 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 1084: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1080: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1081: END IF;
1082: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1083:
1084: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1085: IF l_context_id IS NULL then
1086: l_balance_value:=0;
1087: ELSE
1088: 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 1094: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1090: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1091:
1092:
1093: if g_debug then
1094: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1095: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1096: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1097: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1098: end if;

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

1123: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1124: end if;
1125:
1126:
1127: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1128: IF l_context_id IS NULL then
1129: l_balance_value:=0;
1130: ELSE
1131: 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 1135: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');

1131: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1132: END IF;
1133: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1134:
1135: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1136: IF l_context_id IS NULL then
1137: l_balance_value:=0;
1138: ELSE
1139: 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 1146: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1142:
1143:
1144:
1145: if g_debug then
1146: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1147: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1148: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1149: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1150: end if;

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

1205: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1206: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1207: end if;
1208:
1209: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_REDUCTION_ASG_YTD');
1210: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1211: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1212:
1213: if g_debug then

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

1210: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1211: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1212:
1213: if g_debug then
1214: hr_utility.set_location('STANDARD_TAX_REDUCTION_ASG_YTD',425);
1215: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1216: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1217: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1218: end if;

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

1227: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1228: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1229: end if;
1230:
1231: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD');
1232: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1233: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1234:
1235: if g_debug then

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

1232: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1233: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1234:
1235: if g_debug then
1236: hr_utility.set_location('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD',425);
1237: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1238: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1239: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1240: end if;

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

1283:
1284: l_sum_of_balances:=0;
1285:
1286:
1287: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAXABLE_INCOME_ASG_YTD');
1288: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1289: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1290:
1291: if g_debug then

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

1288: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1289: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1290:
1291: if g_debug then
1292: hr_utility.set_location('STANDARD_TAXABLE_INCOME_ASG_YTD',425);
1293: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1294: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1295: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1296: end if;

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

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

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

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

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

1319: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1320: end if;
1321:
1322:
1323: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD');
1324: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1325: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1326:
1327: if g_debug then

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

1324: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1325: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1326:
1327: if g_debug then
1328: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD',425);
1329: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1330: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1331: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1332: end if;

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

1373: end if;
1374:
1375: l_wt_and_ni_cont:=0;
1376:
1377: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_DEDUCTION_ASG_YTD');
1378: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1379: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1380:
1381:

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

1379: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1380:
1381:
1382: if g_debug then
1383: hr_utility.set_location('STANDARD_TAX_DEDUCTION_ASG_YTD',425);
1384: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1385: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1386: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1387: end if;

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

1399: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1400: end if;
1401:
1402:
1403: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD');
1404: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1405: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1406:
1407:

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

1405: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1406:
1407:
1408: if g_debug then
1409: hr_utility.set_location('RETRO_STANDARD_TAX_DEDUCTION_ASG_YTD',425);
1410: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1411: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1412: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1413: end if;

Line 1429: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_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('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_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('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_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('RETRO_STANDARD_TAX_DEDUCTION_CURRENT_QUARTER_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 1442: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_CORRECTION_ASG_YTD');

1438: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1439: END IF;
1440:
1441:
1442: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('STANDARD_TAX_CORRECTION_ASG_YTD');
1443: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1444: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1445:
1446:

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

1444: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1445:
1446:
1447: if g_debug then
1448: hr_utility.set_location('STANDARD_TAX_CORRECTION_ASG_YTD',425);
1449: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1450: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1451: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1452: end if;

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

1623: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1624: end if;
1625:
1626:
1627: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1628: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1629: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1630:
1631:

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

1629: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1630:
1631:
1632: if g_debug then
1633: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1634: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1635: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1636: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1637: end if;

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

1675: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1676: end if;
1677:
1678:
1679: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1680: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1681: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1682:
1683:

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

1681: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1682:
1683:
1684: if g_debug then
1685: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
1686: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1687: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1688: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1689: end if;

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

1732: end if;
1733:
1734:
1735:
1736: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1737: IF l_context_id IS NULL then
1738: l_balance_value:=0;
1739: ELSE
1740: 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 1745: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1741: END IF;
1742: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1743:
1744: if g_debug then
1745: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1746: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1747: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1748: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1749: end if;

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

1803: end if;
1804:
1805:
1806:
1807: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1808: IF l_context_id IS NULL then
1809: l_balance_value:=0;
1810: ELSE
1811: 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 1817: hr_utility.set_location('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1813: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1814:
1815:
1816: if g_debug then
1817: hr_utility.set_location('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1818: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1819: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1820: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1821: end if;

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

1874:
1875:
1876:
1877:
1878: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1879: IF l_context_id IS NULL then
1880: l_balance_value:=0;
1881: ELSE
1882: 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 1888: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1884: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1885:
1886:
1887: if g_debug then
1888: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1889: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1890: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1891: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1892: end if;

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

1944: end if;
1945:
1946:
1947:
1948: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1949: IF l_context_id IS NULL then
1950: l_balance_value:=0;
1951: ELSE
1952: 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 1958: hr_utility.set_location('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

1954: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1955:
1956:
1957: if g_debug then
1958: hr_utility.set_location('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
1959: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
1960: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1961: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1962: end if;

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

2070: --end if;
2071:
2072: /*for csr_tax_year_assgn_act_id_rec in csr_tax_year_assgn_act_id
2073: loop
2074: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',csr_tax_year_assgn_act_id_rec.date_earned);
2075: 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);
2076:
2077: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2078: FETCH csr_run_result_id into l_run_result_id;

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

2453: pay_run_results prr,
2454: pay_run_result_values prrv,
2455: per_time_periods ptp
2456: where
2457: pet.element_name='Standard Tax Deduction' and
2458: pet.element_type_id=piv.element_type_id and
2459: piv.name='Tax Reduction Flag' and
2460: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and
2461: ppa.payroll_action_id=paa.payroll_action_id and

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

2480: pay_run_results prr,
2481: pay_run_result_values prrv,
2482: per_time_periods ptp
2483: where
2484: pet.element_name='Standard Tax Deduction' and
2485: pet.element_type_id=piv.element_type_id and
2486: piv.name='Tax Reduction Flag' and
2487: --11854614
2488: --ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and

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

2663: pay_input_values_f piv,
2664: pay_run_results prr,
2665: pay_run_result_values prrv
2666: where
2667: pet.element_name='Standard Tax Deduction' and
2668: pet.element_type_id=piv.element_type_id and
2669: piv.name='Tax Code' and
2670: ppa.date_earned between p_tax_year_start_date and p_tax_year_end_date and
2671: ppa.payroll_action_id=paa.payroll_action_id and

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

2689: pay_input_values_f piv,
2690: pay_run_results prr,
2691: pay_run_result_values prrv
2692: where
2693: pet.element_name='Standard Tax Deduction' and
2694: pet.element_type_id=piv.element_type_id and
2695: piv.name='Tax Code' and
2696: --ppa.business_group_id = p_bg_id and
2697: --11854614

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

2903: hr_utility.set_location('Entering get_IZA_contributions',1050);
2904:
2905: l_IZA_contributions:=0;
2906:
2907: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
2908: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2909: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2910:
2911: if g_debug then

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

2908: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2909: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2910:
2911: if g_debug then
2912: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
2913: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2914: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2915: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2916: end if;

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

2927: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2928: end if;
2929:
2930:
2931: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
2932: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2933: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2934:
2935: if g_debug then

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

2932: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2933: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2934:
2935: if g_debug then
2936: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);
2937: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2938: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2939: hr_utility.set_location('l_IZA_contributions'||l_IZA_contributions,425);
2940: end if;

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

2966: l_defined_balance_id number;
2967:
2968: BEGIN
2969:
2970: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_STANDARD_TAX_ASG_YTD');
2971: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2972: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2973:
2974: if g_debug then

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

2971: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2972: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2973:
2974: if g_debug then
2975: hr_utility.set_location('ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);
2976: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2977: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2978: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2979: end if;

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

2988: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2989: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2990: end if;
2991:
2992: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD');
2993: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2994: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2995:
2996: if g_debug then

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

2993: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2994: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2995:
2996: if g_debug then
2997: hr_utility.set_location('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);
2998: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
2999: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3000: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
3001: end if;

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

3050: end if;
3051:
3052:
3053:
3054: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3055: IF l_context_id IS NULL then
3056: l_balance_value:=0;
3057: ELSE
3058: 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 3063: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

3059: END IF;
3060: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3061:
3062: if g_debug then
3063: hr_utility.set_location('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
3064: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
3065: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3066: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3067: end if;

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

3101: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3102: end if;
3103:
3104:
3105: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3106: IF l_context_id IS NULL then
3107: l_balance_value:=0;
3108: ELSE
3109: 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 3115: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);

3111: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3112:
3113:
3114: if g_debug then
3115: hr_utility.set_location('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD',425);
3116: hr_utility.set_location('l_defined_balance_id'||l_defined_balance_id,425);
3117: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3118: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3119: end if;