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 PAY_BALANCE_PKG

Line 834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
838: hr_utility.set_location('SI_INCOME_STANDARD_TAX_ASG_YTD',425);

Line 845: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

841: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
842: end if;
843:
844: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');
845: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
846: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
847:
848: if g_debug then
849: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);

Line 856: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
860: hr_utility.set_location('WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);

Line 867: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 878: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
882: hr_utility.set_location('WAGE_IN_KIND_STANDARD_TAX_ONLY_ASG_YTD',425);

Line 889: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 901: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
905: if g_debug then

Line 914: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

910: end if;
911:
912:
913: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SI_INCOME_SPECIAL_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:
918: if g_debug then

Line 927: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
931: hr_utility.set_location('RETRO_WAGE_IN_MONEY_STANDARD_TAX_ONLY_ASG_YTD',425);

Line 939: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 952: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
956: if g_debug then

Line 964: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 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);

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);
980: END IF;
981: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
982:
983: if g_debug then

Line 996: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

992: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
993: IF l_context_id IS NULL then
994: l_balance_value:=0;
995: ELSE
996: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
997: END IF;
998: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
999:
1000: if g_debug then

Line 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);

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);
1013: END IF;
1014: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1015:
1016: if g_debug then

Line 1028: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

1024: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
1025: IF l_context_id IS NULL then
1026: l_balance_value:=0;
1027: ELSE
1028: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
1029: END IF;
1030: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1031:
1032: if g_debug then

Line 1041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1037: end if;
1038:
1039:
1040: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1042: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1043:
1044: if g_debug then
1045: hr_utility.set_location('EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD',425);

Line 1052: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1048: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1049: end if;
1050:
1051: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1052: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1053: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1054:
1055: if g_debug then
1056: hr_utility.set_location('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD',425);

Line 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);

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);
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');

Line 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);

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);
1076: END IF;
1077: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1078:
1079:

Line 1092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

1088: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1089: IF l_context_id IS NULL then
1090: l_balance_value:=0;
1091: ELSE
1092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1093: END IF;
1094: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1095:
1096:

Line 1101: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

1097: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1098: IF l_context_id IS NULL then
1099: l_balance_value:=0;
1100: ELSE
1101: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);
1102: END IF;
1103: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1104:
1105:

Line 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);

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);
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');

Line 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);

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);
1127: END IF;
1128: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1129:
1130:

Line 1144: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

1140: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1141: IF l_context_id IS NULL then
1142: l_balance_value:=0;
1143: ELSE
1144: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1145: END IF;
1146: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1147:
1148:

Line 1161: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

1157: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1158: IF l_context_id IS NULL then
1159: l_balance_value:=0;
1160: ELSE
1161: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);
1162: END IF;
1163: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1164:
1165:

Line 1175: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1171: end if;
1172:
1173:
1174: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD');
1175: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1176: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1177:
1178: if g_debug then
1179: hr_utility.set_location('PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD',425);

Line 1186: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1182: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1183: end if;
1184:
1185: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD');
1186: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1187: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1188:
1189: if g_debug then
1190: hr_utility.set_location('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD',425);

Line 1197: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
1201: hr_utility.set_location('STANDARD_TAX_REDUCTION_ASG_YTD',425);

Line 1208: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 1219: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
1223: hr_utility.set_location('RETRO_STANDARD_TAX_REDUCTION_ASG_YTD',425);

Line 1230: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 1275: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
1279: hr_utility.set_location('STANDARD_TAXABLE_INCOME_ASG_YTD',425);

Line 1287: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 1299: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
1303: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_CURRENT_QUARTER_ASG_YTD',425);

Line 1311: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
1315: hr_utility.set_location('RETRO_STANDARD_TAXABLE_INCOME_ASG_YTD',425);

Line 1323: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

Line 1365: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1369: if g_debug then

Line 1378: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1374: end if;
1375:
1376:
1377: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_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:
1382: if g_debug then

Line 1391: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1395: if g_debug then

Line 1404: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1400: end if;
1401:
1402:
1403: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_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:
1408: if g_debug then

Line 1417: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1421: if g_debug then

Line 1430: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1434: if g_debug then

Line 1443: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1439: end if;
1440:
1441:
1442: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_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:
1447: if g_debug then

Line 1488: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1484:
1485: l_labour_discount:=0;
1486:
1487: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LABOUR_TAX_REDUCTION_ASG_YTD');
1488: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1489: l_labour_discount:= l_labour_discount + l_balance_value;
1490:
1491:
1492: if g_debug then

Line 1500: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1496: hr_utility.set_location('l_labour_discount'||l_labour_discount,425);
1497: end if;
1498:
1499: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LABOUR_TAX_REDUCTION_ASG_YTD');
1500: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1501: l_labour_discount:= l_labour_discount + l_balance_value;
1502:
1503: if g_debug then
1504: hr_utility.set_location('RETRO_LABOUR_TAX_REDUCTION_ASG_YTD',425);

Line 1547: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1543:
1544:
1545:
1546: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1547: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1548: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1549:
1550:
1551: if g_debug then

Line 1561: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1557:
1558:
1559:
1560: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1561: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1562: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1563:
1564:
1565: if g_debug then

Line 1575: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1571:
1572:
1573:
1574: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1575: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1576: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1577:
1578:
1579: if g_debug then

Line 1588: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1584: end if;
1585:
1586:
1587: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1588: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1589: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1590:
1591:
1592: if g_debug then

Line 1602: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1598:
1599:
1600:
1601: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_IZA_CONTRIBUTION_ASG_YTD');
1602: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1603: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1604:
1605:
1606: if g_debug then

Line 1615: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1619: if g_debug then

Line 1628: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1624: end if;
1625:
1626:
1627: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_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:
1632: if g_debug then

Line 1641: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1637: end if;
1638:
1639:
1640: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_ASG_YTD');
1641: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1642: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1643:
1644:
1645: if g_debug then

Line 1654: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1650: end if;
1651:
1652:
1653: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_IZA_CONTRIBUTION_ASG_YTD');
1654: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1655: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1656:
1657:
1658: if g_debug then

Line 1667: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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:
1671: if g_debug then

Line 1680: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1676: end if;
1677:
1678:
1679: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_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:
1684: if g_debug then

Line 1692: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

1688: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1689: end if;
1690:
1691: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_ASG_YTD');
1692: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1693: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1694:
1695:
1696: if g_debug then

Line 1709: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1705: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1706: IF l_context_id IS NULL then
1707: l_balance_value:=0;
1708: ELSE
1709: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1710: END IF;
1711: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1712:
1713:

Line 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);

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);
1728: END IF;
1729: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1730:
1731: if g_debug then

Line 1744: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1740: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1741: IF l_context_id IS NULL then
1742: l_balance_value:=0;
1743: ELSE
1744: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1745: END IF;
1746: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1747:
1748:

Line 1762: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1758: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1759: IF l_context_id IS NULL then
1760: l_balance_value:=0;
1761: ELSE
1762: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1763: END IF;
1764: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1765:
1766:

Line 1780: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1776: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1777: IF l_context_id IS NULL then
1778: l_balance_value:=0;
1779: ELSE
1780: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1781: END IF;
1782: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1783:
1784:

Line 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);

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);
1799: END IF;
1800: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1801:
1802:

Line 1816: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1812: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1813: IF l_context_id IS NULL then
1814: l_balance_value:=0;
1815: ELSE
1816: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1817: END IF;
1818: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1819:
1820:

Line 1834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1830: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1831: IF l_context_id IS NULL then
1832: l_balance_value:=0;
1833: ELSE
1834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1835: END IF;
1836: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1837:
1838: if g_debug then

Line 1850: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1846: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1847: IF l_context_id IS NULL then
1848: l_balance_value:=0;
1849: ELSE
1850: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1851: END IF;
1852: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1853:
1854:

Line 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);

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);
1870: END IF;
1871: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1872:
1873:

Line 1886: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1882: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1883: IF l_context_id IS NULL then
1884: l_balance_value:=0;
1885: ELSE
1886: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1887: END IF;
1888: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1889:
1890:

Line 1904: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1900: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1901: IF l_context_id IS NULL then
1902: l_balance_value:=0;
1903: ELSE
1904: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1905: END IF;
1906: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1907:
1908:

Line 1921: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1917: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1918: IF l_context_id IS NULL then
1919: l_balance_value:=0;
1920: ELSE
1921: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1922: END IF;
1923: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1924:
1925:

Line 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);

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);
1940: END IF;
1941: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1942:
1943:

Line 1957: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1953: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1954: IF l_context_id IS NULL then
1955: l_balance_value:=0;
1956: ELSE
1957: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1958: END IF;
1959: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1960:
1961:

Line 1975: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

1971: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1972: IF l_context_id IS NULL then
1973: l_balance_value:=0;
1974: ELSE
1975: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1976: END IF;
1977: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1978:
1979:

Line 2150: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2146:
2147: g_debug:=true;
2148:
2149: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TRAVEL_ALLOWANCE_ASG_YTD');
2150: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2151: if l_balance_value <> 0 then
2152: l_spl_indicator1 := '04';
2153: l_spl_indicator1_amount := l_balance_value;
2154: else

Line 2166: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2162: hr_utility.set_location('l_spl_indicator1_amount'||l_spl_indicator1_amount,427);
2163: end if;
2164:
2165: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_SEA_DAYS_DISCOUNT_ASG_YTD');
2166: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2167: if l_balance_value <> 0 then
2168: l_spl_indicator2 := '17';
2169: l_spl_indicator2_amount := l_balance_value;
2170: else

Line 2183: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2179: end if;
2180:
2181:
2182: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_ABW_ALLOWANCE_ASG_YTD');
2183: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2184: if l_balance_value <> 0 then
2185: l_spl_indicator3 := '25';
2186: l_spl_indicator3_amount := l_balance_value;
2187: else

Line 2201: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2197: end if;
2198:
2199:
2200: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_YTD');
2201: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2202: if l_balance_value <> 0 then
2203: l_spl_indicator4 := '26';
2204: l_spl_indicator4_amount := l_balance_value;
2205: else

Line 2219: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2215: end if;
2216:
2217:
2218: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_WAO_ALLOWANCE_ASG_YTD');
2219: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2220: if l_balance_value <> 0 then
2221: l_spl_indicator5 := '61';
2222: l_spl_indicator5_amount := l_balance_value;
2223: else

Line 2235: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2231: hr_utility.set_location('l_spl_indicator5_amount'||l_spl_indicator5_amount,427);
2232: end if;
2233:
2234: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TOTAL_ZFW_CONTRIBUTION_ASG_YTD');
2235: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2236: if l_balance_value <> 0 then
2237: l_spl_indicator6 := '64';
2238: l_spl_indicator6_amount := l_balance_value;
2239: else

Line 2352: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2348:
2349: l_Private_Use_Car:=0;
2350:
2351: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PRIVATE_USE_CAR_ASG_YTD');
2352: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2353: l_Private_Use_Car:=l_balance_value;
2354: hr_utility.set_location('l_Private_Use_Car'||l_Private_Use_Car,425);
2355:
2356: if g_debug then

Line 2385: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2381:
2382: l_NET_EXPENSE_ALLOWANCE:=0;
2383:
2384: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EXPENSE_ALLOWANCE_ASG_YTD');
2385: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2386: l_Net_Expense_Allowance:=l_balance_value;
2387:
2388: if g_debug then
2389: hr_utility.set_location('l_Net_Expense_Allowance'||l_Net_Expense_Allowance,425);

Line 2874: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
2878: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

Line 2886: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2882: end if;
2883:
2884:
2885: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
2886: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2887: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2888:
2889: if g_debug then
2890: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD',425);

Line 2898: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
2902: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_STANDARD_TAX_ASG_YTD',425);

Line 2910: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2906: end if;
2907:
2908:
2909: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
2910: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2911: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2912:
2913: if g_debug then
2914: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD',425);

Line 2937: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
2941: hr_utility.set_location('ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);

Line 2948: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2944: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2945: end if;
2946:
2947: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_SPECIAL_TAX_ASG_YTD');
2948: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2949: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2950:
2951: if g_debug then
2952: hr_utility.set_location('ZVW_INCOME_SPECIAL_TAX_ASG_YTD',425);

Line 2959: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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
2963: hr_utility.set_location('RETRO_ZVW_INCOME_STANDARD_TAX_ASG_YTD',425);

Line 2970: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

2966: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2967: end if;
2968:
2969: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_SPECIAL_TAX_ASG_YTD');
2970: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2971: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2972:
2973: if g_debug then
2974: hr_utility.set_location('RETRO_ZVW_INCOME_SPECIAL_TAX_ASG_YTD',425);

Line 3006: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

3002: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
3003: IF l_context_id IS NULL then
3004: l_balance_value:=0;
3005: ELSE
3006: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
3007: END IF;
3008: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3009:
3010:

Line 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);

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);
3025: END IF;
3026: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3027:
3028: if g_debug then

Line 3041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

3037: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
3038: IF l_context_id IS NULL then
3039: l_balance_value:=0;
3040: ELSE
3041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
3042: END IF;
3043: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3044:
3045:

Line 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);

3054: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_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);
3059: END IF;
3060: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3061:
3062:

Line 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);

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);
3076: END IF;
3077: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3078:
3079:

Line 3092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

3088: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
3089: IF l_context_id IS NULL then
3090: l_balance_value:=0;
3091: ELSE
3092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
3093: END IF;
3094: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3095:
3096:

Line 3131: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3127:
3128: l_Value_Private_Use_Car:=0;
3129:
3130: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('VALUE_PRIVATE_USAGE_COMPANY_CAR_ASG_YTD');
3131: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3132: l_Value_Private_Use_Car:=l_balance_value;
3133: hr_utility.set_location('l_Value_Private_Use_Car'||l_Value_Private_Use_Car,425);
3134:
3135: if g_debug then

Line 3163: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3159:
3160: l_LSS_Saved_Amount:=0;
3161:
3162: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3163: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3164: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3165:
3166: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3167: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

Line 3167: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3163: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3164: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3165:
3166: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3167: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3168: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3169:
3170: hr_utility.set_location('l_LSS_Saved_Amount'||l_LSS_Saved_Amount,425);
3171:

Line 3200: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3196:
3197: l_Employer_Part_Child_Care:=0;
3198:
3199: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('CHILD_CARE_EMPLOYER_CONTRIBUTION_ASG_YTD');
3200: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3201: l_Employer_Part_Child_Care:=l_balance_value;
3202: hr_utility.set_location('l_Employer_Part_Child_Care'||l_Employer_Part_Child_Care,425);
3203:
3204: if g_debug then

Line 3232: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3228:
3229: l_Allowance_On_Disability:=0;
3230:
3231: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PAID_DISABILITY_ALLOWANCE_ASG_YTD');
3232: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3233: l_Allowance_On_Disability:=l_balance_value;
3234: hr_utility.set_location('l_Allowance_On_Disability'||l_Allowance_On_Disability,425);
3235:
3236: if g_debug then

Line 3264: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3260:
3261: l_Applied_LCLD:=0;
3262:
3263: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3264: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3265: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;
3266:
3267: /* l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3268: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

Line 3268: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3264: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3265: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;
3266:
3267: /* l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3268: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3269: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;*/
3270:
3271: hr_utility.set_location('l_Applied_LCLD'||l_Applied_LCLD,425);
3272:

Line 3445: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

3441:
3442: IF l_defined_balance_id is NULL THEN
3443: l_balance_value := 0;
3444: ELSE
3445: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3446: END IF;
3447:
3448: l_balance_string := l_balance_string||fnd_number.number_to_canonical(ceil(l_balance_value))||'|';
3449: