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 847: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

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

854: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
855: end if;
856:
857: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');
858: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
859: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
860:
861: if g_debug then
862: hr_utility.set_location('SI_INCOME_SPECIAL_TAX_ASG_YTD',425);

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

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

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

876: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
877: end if;
878:
879: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD');
880: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
881: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
882:
883: if g_debug then
884: hr_utility.set_location('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD',425);

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

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

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

898: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
899: end if;
900:
901: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_KIND_SPECIAL_TAX_ONLY_ASG_YTD');
902: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
903: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
904:
905:
906: if g_debug then

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

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

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

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

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_MONEY_SPECIAL_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 965: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

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

973: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
974: end if;
975:
976: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_KIND_SPECIAL_TAX_ONLY_ASG_YTD');
977: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
978: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
979:
980: if g_debug then
981: hr_utility.set_location('RETRO_WAGE_IN_KIND_SPECIAL_TAX_ONLY_ASG_YTD',425);

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

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);
993: END IF;
994: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
995:
996: if g_debug then

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

1005: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
1006: IF l_context_id IS NULL then
1007: l_balance_value:=0;
1008: ELSE
1009: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
1010: END IF;
1011: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1012:
1013: if g_debug then

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

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);
1026: END IF;
1027: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1028:
1029: if g_debug then

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

1037: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
1038: IF l_context_id IS NULL then
1039: l_balance_value:=0;
1040: ELSE
1041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
1042: END IF;
1043: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1044:
1045: if g_debug then

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

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

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

1061: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1062: end if;
1063:
1064: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1065: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1066: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1067:
1068: if g_debug then
1069: hr_utility.set_location('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD',425);

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

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

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

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);
1089: END IF;
1090: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1091:
1092:

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

1101: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1102: IF l_context_id IS NULL then
1103: l_balance_value:=0;
1104: ELSE
1105: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1106: END IF;
1107: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1108:
1109:

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

1110: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1111: IF l_context_id IS NULL then
1112: l_balance_value:=0;
1113: ELSE
1114: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);
1115: END IF;
1116: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1117:
1118:

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

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

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

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);
1140: END IF;
1141: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1142:
1143:

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

1153: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1154: IF l_context_id IS NULL then
1155: l_balance_value:=0;
1156: ELSE
1157: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1158: END IF;
1159: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1160:
1161:

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

1170: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1171: IF l_context_id IS NULL then
1172: l_balance_value:=0;
1173: ELSE
1174: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);
1175: END IF;
1176: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1177:
1178:

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

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

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

1195: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1196: end if;
1197:
1198: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD');
1199: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1200: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1201:
1202: if g_debug then
1203: hr_utility.set_location('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD',425);

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

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

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

1217: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1218: end if;
1219:
1220: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_TAX_REDUCTION_ASG_YTD');
1221: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1222: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1223:
1224: if g_debug then
1225: hr_utility.set_location('SPECIAL_TAX_REDUCTION_ASG_YTD',425);

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

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

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

1239: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1240: end if;
1241:
1242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAX_REDUCTION_ASG_YTD');
1243: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1244: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1245:
1246: if g_debug then
1247: hr_utility.set_location('RETRO_SPECIAL_TAX_REDUCTION_ASG_YTD',425);

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

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

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

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

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

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

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

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

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

1332: end if;
1333:
1334:
1335: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');
1336: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1337: l_sum_of_balances:=l_sum_of_balances + l_balance_value;
1338:
1339: if g_debug then
1340: hr_utility.set_location('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD',425);

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

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:
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('SPECIAL_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_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:
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_SPECIAL_TAX_DEDUCTION_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('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:
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('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:
1447: if g_debug then

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

1452: end if;
1453:
1454:
1455: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_TAX_CORRECTION_ASG_YTD');
1456: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1457: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1458:
1459:
1460: if g_debug then

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

1497:
1498: l_labour_discount:=0;
1499:
1500: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LABOUR_TAX_REDUCTION_ASG_YTD');
1501: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1502: l_labour_discount:= l_labour_discount + l_balance_value;
1503:
1504:
1505: if g_debug then

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

1509: hr_utility.set_location('l_labour_discount'||l_labour_discount,425);
1510: end if;
1511:
1512: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LABOUR_TAX_REDUCTION_ASG_YTD');
1513: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1514: l_labour_discount:= l_labour_discount + l_balance_value;
1515:
1516: if g_debug then
1517: hr_utility.set_location('RETRO_LABOUR_TAX_REDUCTION_ASG_YTD',425);

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

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

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

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

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

1584:
1585:
1586:
1587: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_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 1601: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

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

1611:
1612:
1613:
1614: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_IZA_CONTRIBUTION_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_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:
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_SPECIAL_TAX_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('EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_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_EMPLOYEE_IZA_CONTRIBUTION_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_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:
1684: if g_debug then

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

1689: end if;
1690:
1691:
1692: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
1693: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1694: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1695:
1696:
1697: if g_debug then

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

1701: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1702: end if;
1703:
1704: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_ASG_YTD');
1705: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1706: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1707:
1708:
1709: if g_debug then

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

1718: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1719: IF l_context_id IS NULL then
1720: l_balance_value:=0;
1721: ELSE
1722: 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: END IF;
1724: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1725:
1726:

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

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);
1741: END IF;
1742: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1743:
1744: if g_debug then

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

1753: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1754: IF l_context_id IS NULL then
1755: l_balance_value:=0;
1756: ELSE
1757: 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: END IF;
1759: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1760:
1761:

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

1771: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1772: IF l_context_id IS NULL then
1773: l_balance_value:=0;
1774: ELSE
1775: 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: END IF;
1777: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1778:
1779:

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

1789: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1790: IF l_context_id IS NULL then
1791: l_balance_value:=0;
1792: ELSE
1793: 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: END IF;
1795: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1796:
1797:

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

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);
1812: END IF;
1813: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1814:
1815:

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

1825: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1826: IF l_context_id IS NULL then
1827: l_balance_value:=0;
1828: ELSE
1829: 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: END IF;
1831: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1832:
1833:

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

1843: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1844: IF l_context_id IS NULL then
1845: l_balance_value:=0;
1846: ELSE
1847: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1848: END IF;
1849: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1850:
1851: if g_debug then

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

1859: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1860: IF l_context_id IS NULL then
1861: l_balance_value:=0;
1862: ELSE
1863: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1864: END IF;
1865: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1866:
1867:

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

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);
1883: END IF;
1884: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1885:
1886:

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

1895: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1896: IF l_context_id IS NULL then
1897: l_balance_value:=0;
1898: ELSE
1899: 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: END IF;
1901: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1902:
1903:

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

1913: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1914: IF l_context_id IS NULL then
1915: l_balance_value:=0;
1916: ELSE
1917: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1918: END IF;
1919: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1920:
1921:

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

1930: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1931: IF l_context_id IS NULL then
1932: l_balance_value:=0;
1933: ELSE
1934: 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: END IF;
1936: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1937:
1938:

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

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);
1953: END IF;
1954: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1955:
1956:

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

1966: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1967: IF l_context_id IS NULL then
1968: l_balance_value:=0;
1969: ELSE
1970: 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: END IF;
1972: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1973:
1974:

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

1984: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1985: IF l_context_id IS NULL then
1986: l_balance_value:=0;
1987: ELSE
1988: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);
1989: END IF;
1990: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1991:
1992:

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

2164:
2165: g_debug:=true;
2166:
2167: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TRAVEL_ALLOWANCE_ASG_YTD');
2168: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2169: if l_balance_value <> 0 then
2170: l_spl_indicator1 := '04';
2171: l_spl_indicator1_amount := l_balance_value;
2172: else

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

2180: hr_utility.set_location('l_spl_indicator1_amount'||l_spl_indicator1_amount,427);
2181: end if;
2182:
2183: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_SEA_DAYS_DISCOUNT_ASG_YTD');
2184: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2185: if l_balance_value <> 0 then
2186: l_spl_indicator2 := '17';
2187: l_spl_indicator2_amount := l_balance_value;
2188: 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_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_indicator3 := '25';
2204: l_spl_indicator3_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_ABW_ALLOWANCE_STOPPAGE_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_indicator4 := '26';
2222: l_spl_indicator4_amount := l_balance_value;
2223: else

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

2233: end if;
2234:
2235:
2236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_WAO_ALLOWANCE_ASG_YTD');
2237: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2238: if l_balance_value <> 0 then
2239: l_spl_indicator5 := '61';
2240: l_spl_indicator5_amount := l_balance_value;
2241: else

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

2249: hr_utility.set_location('l_spl_indicator5_amount'||l_spl_indicator5_amount,427);
2250: end if;
2251:
2252: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TOTAL_ZFW_CONTRIBUTION_ASG_YTD');
2253: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2254: if l_balance_value <> 0 then
2255: l_spl_indicator6 := '64';
2256: l_spl_indicator6_amount := l_balance_value;
2257: else

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

2366:
2367: l_Private_Use_Car:=0;
2368:
2369: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PRIVATE_USE_CAR_ASG_YTD');
2370: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2371: l_Private_Use_Car:=l_balance_value;
2372: hr_utility.set_location('l_Private_Use_Car'||l_Private_Use_Car,425);
2373:
2374: if g_debug then

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

2399:
2400: l_NET_EXPENSE_ALLOWANCE:=0;
2401:
2402: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EXPENSE_ALLOWANCE_ASG_YTD');
2403: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2404: l_Net_Expense_Allowance:=l_balance_value;
2405:
2406: if g_debug then
2407: hr_utility.set_location('l_Net_Expense_Allowance'||l_Net_Expense_Allowance,425);

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

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

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

2916: end if;
2917:
2918:
2919: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
2920: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2921: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2922:
2923: if g_debug then
2924: hr_utility.set_location('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD',425);

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

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

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

2940: end if;
2941:
2942:
2943: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
2944: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2945: l_IZA_contributions:=l_IZA_contributions + l_balance_value;
2946:
2947: if g_debug then
2948: hr_utility.set_location('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD',425);

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

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

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

2978: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2979: end if;
2980:
2981: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_SPECIAL_TAX_ASG_YTD');
2982: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
2983: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
2984:
2985: if g_debug then
2986: hr_utility.set_location('ZVW_INCOME_SPECIAL_TAX_ASG_YTD',425);

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

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

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

3000: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
3001: end if;
3002:
3003: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_SPECIAL_TAX_ASG_YTD');
3004: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3005: l_ZVW_basis:=l_ZVW_basis + l_balance_value;
3006:
3007: if g_debug then
3008: hr_utility.set_location('RETRO_ZVW_INCOME_SPECIAL_TAX_ASG_YTD',425);

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

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

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('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);
3059: END IF;
3060: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3061:
3062: if g_debug then

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('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_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_NET_EMPLOYEE_SI_CONTRIBUTION_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 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);

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);
3110: END IF;
3111: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3112:
3113:

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

3122: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
3123: IF l_context_id IS NULL then
3124: l_balance_value:=0;
3125: ELSE
3126: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);
3127: END IF;
3128: l_ZVW_Contribution:=l_ZVW_Contribution + l_balance_value;
3129:
3130:

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

3161:
3162: l_Value_Private_Use_Car:=0;
3163:
3164: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('VALUE_PRIVATE_USAGE_COMPANY_CAR_ASG_YTD');
3165: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3166: l_Value_Private_Use_Car:=l_balance_value;
3167: hr_utility.set_location('l_Value_Private_Use_Car'||l_Value_Private_Use_Car,425);
3168:
3169: if g_debug then

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

3193:
3194: l_LSS_Saved_Amount:=0;
3195:
3196: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3197: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3198: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3199:
3200: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3201: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

3197: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3198: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3199:
3200: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');
3201: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3202: l_LSS_Saved_Amount:=l_LSS_Saved_Amount + l_balance_value;
3203:
3204: hr_utility.set_location('l_LSS_Saved_Amount'||l_LSS_Saved_Amount,425);
3205:

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

3230:
3231: l_Employer_Part_Child_Care:=0;
3232:
3233: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('CHILD_CARE_EMPLOYER_CONTRIBUTION_ASG_YTD');
3234: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3235: l_Employer_Part_Child_Care:=l_balance_value;
3236: hr_utility.set_location('l_Employer_Part_Child_Care'||l_Employer_Part_Child_Care,425);
3237:
3238: if g_debug then

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

3262:
3263: l_Allowance_On_Disability:=0;
3264:
3265: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PAID_DISABILITY_ALLOWANCE_ASG_YTD');
3266: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3267: l_Allowance_On_Disability:=l_balance_value;
3268: hr_utility.set_location('l_Allowance_On_Disability'||l_Allowance_On_Disability,425);
3269:
3270: if g_debug then

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

3294:
3295: l_Applied_LCLD:=0;
3296:
3297: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3298: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3299: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;
3300:
3301: /* l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3302: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);

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

3298: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3299: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;
3300:
3301: /* l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');
3302: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3303: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;*/
3304:
3305: hr_utility.set_location('l_Applied_LCLD'||l_Applied_LCLD,425);
3306:

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

3475:
3476: IF l_defined_balance_id is NULL THEN
3477: l_balance_value := 0;
3478: ELSE
3479: l_balance_value := pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
3480: END IF;
3481:
3482: l_balance_string := l_balance_string||fnd_number.number_to_canonical(ceil(l_balance_value))||'|';
3483: