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_NL_GENERAL

Line 418: l_asg_dates_flag := pay_nl_general.get_period_asg_dates(l_assignment_id,l_tax_year_start_date,l_tax_year_end_date,l_assgt_start_date,l_assgt_end_date);

414: if l_assgt_act_id is not null then
415:
416: l_ATS_Process_Date:=l_tax_year_end_date;
417:
418: l_asg_dates_flag := pay_nl_general.get_period_asg_dates(l_assignment_id,l_tax_year_start_date,l_tax_year_end_date,l_assgt_start_date,l_assgt_end_date);
419:
420: if l_assgt_start_date < l_tax_year_start_date then
421: l_asg_start_date:=to_char(l_tax_year_start_date,'DDMMYYYY');
422: else

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

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

Line 857: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_SPECIAL_TAX_ASG_YTD');

853: hr_utility.set_location('l_balance_value'||l_balance_value,425);
854: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
855: end if;
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

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

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

Line 879: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_MONEY_SPECIAL_TAX_ONLY_ASG_YTD');

875: hr_utility.set_location('l_balance_value'||l_balance_value,425);
876: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
877: end if;
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

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

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

Line 901: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('WAGE_IN_KIND_SPECIAL_TAX_ONLY_ASG_YTD');

897: hr_utility.set_location('l_balance_value'||l_balance_value,425);
898: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
899: end if;
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:

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

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

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

922: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
923: end if;
924:
925:
926: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_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:

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

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

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

947: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
948: end if;
949:
950:
951: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_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:

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

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

Line 976: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_WAGE_IN_KIND_SPECIAL_TAX_ONLY_ASG_YTD');

972: hr_utility.set_location('l_balance_value'||l_balance_value,425);
973: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
974: end if;
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

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

984: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
985: end if;
986:
987:
988: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
989: IF l_context_id IS NULL then
990: l_balance_value:=0;
991: ELSE
992: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 1005: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

1001: end if;
1002:
1003:
1004:
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);

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

1017: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1018: end if;
1019:
1020:
1021: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_STANDARD_TAX_ASG_YTD');
1022: IF l_context_id IS NULL then
1023: l_balance_value:=0;
1024: ELSE
1025: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 1037: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

1033: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1034: end if;
1035:
1036:
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);

Line 1053: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

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

Line 1064: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

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

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

1072: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1073: end if;
1074:
1075:
1076: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1077: IF l_context_id IS NULL then
1078: l_balance_value:=0;
1079: ELSE
1080: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

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

1080: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1081: END IF;
1082: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1083:
1084: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1085: IF l_context_id IS NULL then
1086: l_balance_value:=0;
1087: ELSE
1088: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

Line 1101: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1097: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1098: end if;
1099:
1100:
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);

Line 1110: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1106: END IF;
1107: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1108:
1109:
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);

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

1123: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1124: end if;
1125:
1126:
1127: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1128: IF l_context_id IS NULL then
1129: l_balance_value:=0;
1130: ELSE
1131: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

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

1131: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);
1132: END IF;
1133: l_sum_of_balances:=l_sum_of_balances - l_balance_value;
1134:
1135: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1136: IF l_context_id IS NULL then
1137: l_balance_value:=0;
1138: ELSE
1139: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

Line 1153: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1149: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1150: end if;
1151:
1152:
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);

Line 1170: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1166: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1167: end if;
1168:
1169:
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);

Line 1187: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD');

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

Line 1198: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_PRE_TAX_ONLY_DEDUCTIONS_ASG_YTD');

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

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

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

Line 1220: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_TAX_REDUCTION_ASG_YTD');

1216: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1217: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1218: end if;
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

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

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

Line 1242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAX_REDUCTION_ASG_YTD');

1238: hr_utility.set_location('l_balance_value'||l_balance_value,425);
1239: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1240: end if;
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

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

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

Line 1299: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_TAXABLE_INCOME_ASG_YTD');

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

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

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

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

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

Line 1335: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_TAXABLE_INCOME_ASG_YTD');

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

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

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

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

1386: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1387: end if;
1388:
1389:
1390: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('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:

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

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

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

1412: hr_utility.set_location('l_wt_and_ni_cont'||l_wt_and_ni_cont,425);
1413: end if;
1414:
1415:
1416: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_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:

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

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

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

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

Line 1455: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_TAX_CORRECTION_ASG_YTD');

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

Line 1500: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LABOUR_TAX_REDUCTION_ASG_YTD');

1496: end if;
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:

Line 1512: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LABOUR_TAX_REDUCTION_ASG_YTD');

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

Line 1559: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

1555: l_context_id:=get_context_id('SOURCE_TEXT');
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:

Line 1573: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

1569: end if;
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:

Line 1587: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

1583: end if;
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:

Line 1600: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');

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

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

1610: end if;
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:

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

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

Line 1640: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

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

Line 1653: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_ASG_YTD');

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

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

1662: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1663: end if;
1664:
1665:
1666: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_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:

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

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

Line 1692: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

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

Line 1704: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_ASG_YTD');

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

Line 1718: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');

1714: end if;
1715:
1716:
1717:
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);

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

1732: end if;
1733:
1734:
1735:
1736: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1737: IF l_context_id IS NULL then
1738: l_balance_value:=0;
1739: ELSE
1740: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1753: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1749: end if;
1750:
1751:
1752:
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);

Line 1771: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');

1767: end if;
1768:
1769:
1770:
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);

Line 1789: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');

1785: end if;
1786:
1787:
1788:
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);

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

1803: end if;
1804:
1805:
1806:
1807: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1808: IF l_context_id IS NULL then
1809: l_balance_value:=0;
1810: ELSE
1811: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1825: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1821: end if;
1822:
1823:
1824:
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);

Line 1843: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');

1839: end if;
1840:
1841:
1842:
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);

Line 1859: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');

1855: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1856: end if;
1857:
1858:
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);

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

1874:
1875:
1876:
1877:
1878: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1879: IF l_context_id IS NULL then
1880: l_balance_value:=0;
1881: ELSE
1882: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1895: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1891: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1892: end if;
1893:
1894:
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);

Line 1913: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');

1909: end if;
1910:
1911:
1912:
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);

Line 1930: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');

1926: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1927: end if;
1928:
1929:
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);

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

1944: end if;
1945:
1946:
1947:
1948: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
1949: IF l_context_id IS NULL then
1950: l_balance_value:=0;
1951: ELSE
1952: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

Line 1966: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

1962: end if;
1963:
1964:
1965:
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);

Line 1984: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');

1980: end if;
1981:
1982:
1983:
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);

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

2070: --end if;
2071:
2072: /*for csr_tax_year_assgn_act_id_rec in csr_tax_year_assgn_act_id
2073: loop
2074: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',csr_tax_year_assgn_act_id_rec.date_earned);
2075: l_input_value_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Special Indicators',csr_tax_year_assgn_act_id_rec.date_earned);
2076:
2077: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2078: FETCH csr_run_result_id into l_run_result_id;

Line 2075: l_input_value_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Special Indicators',csr_tax_year_assgn_act_id_rec.date_earned);

2071:
2072: /*for csr_tax_year_assgn_act_id_rec in csr_tax_year_assgn_act_id
2073: loop
2074: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',csr_tax_year_assgn_act_id_rec.date_earned);
2075: l_input_value_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Special Indicators',csr_tax_year_assgn_act_id_rec.date_earned);
2076:
2077: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2078: FETCH csr_run_result_id into l_run_result_id;
2079: CLOSE csr_run_result_id;

Line 2081: l_run_result_value:=pay_nl_general.get_run_result_value(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id,l_input_value_id,l_run_result_id,'C');

2077: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2078: FETCH csr_run_result_id into l_run_result_id;
2079: CLOSE csr_run_result_id;
2080:
2081: l_run_result_value:=pay_nl_general.get_run_result_value(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id,l_input_value_id,l_run_result_id,'C');
2082:
2083: IF substr (l_run_result_value, 1, 2) = '01' OR
2084: substr (l_run_result_value, 3, 2) = '01' OR
2085: substr (l_run_result_value, 5, 2) = '01' OR

Line 2167: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TRAVEL_ALLOWANCE_ASG_YTD');

2163: --end if;
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;

Line 2183: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_SEA_DAYS_DISCOUNT_ASG_YTD');

2179: hr_utility.set_location('l_spl_indicator1'||l_spl_indicator1,427);
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;

Line 2200: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_ABW_ALLOWANCE_ASG_YTD');

2196: hr_utility.set_location('TAX_SEA_DAYS_DISCOUNT_ASG_YTD',427);
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;

Line 2218: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_ABW_ALLOWANCE_STOPPAGE_ASG_YTD');

2214: hr_utility.set_location('l_spl_indicator3_amount'||l_spl_indicator3_amount,427);
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;

Line 2236: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_WAO_ALLOWANCE_ASG_YTD');

2232: hr_utility.set_location('l_spl_indicator4_amount'||l_spl_indicator4_amount,427);
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;

Line 2252: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('TAX_TOTAL_ZFW_CONTRIBUTION_ASG_YTD');

2248: hr_utility.set_location('l_spl_indicator5'||l_spl_indicator5,427);
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;

Line 2369: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PRIVATE_USE_CAR_ASG_YTD');

2365: end if;
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:

Line 2402: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EXPENSE_ALLOWANCE_ASG_YTD');

2398: end if;
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

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

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

Line 2919: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

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

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

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

Line 2943: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');

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

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

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

Line 2981: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('ZVW_INCOME_SPECIAL_TAX_ASG_YTD');

2977: hr_utility.set_location('l_balance_value'||l_balance_value,425);
2978: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
2979: end if;
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

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

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

Line 3003: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_ZVW_INCOME_SPECIAL_TAX_ASG_YTD');

2999: hr_utility.set_location('l_balance_value'||l_balance_value,425);
3000: hr_utility.set_location('l_ZVW_basis'||l_ZVW_basis,425);
3001: end if;
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

Line 3036: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');

3032:
3033: l_context_id:=get_context_id('SOURCE_TEXT');
3034:
3035:
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);

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

3050: end if;
3051:
3052:
3053:
3054: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3055: IF l_context_id IS NULL then
3056: l_balance_value:=0;
3057: ELSE
3058: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

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

3067: end if;
3068:
3069:
3070:
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);

Line 3088: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');

3084: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3085: end if;
3086:
3087:
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);

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

3101: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3102: end if;
3103:
3104:
3105: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_STANDARD_TAX_ASG_SIT_YTD');
3106: IF l_context_id IS NULL then
3107: l_balance_value:=0;
3108: ELSE
3109: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

Line 3122: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');

3118: hr_utility.set_location('l_ZVW_Contribution'||l_ZVW_Contribution,425);
3119: end if;
3120:
3121:
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);

Line 3164: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('VALUE_PRIVATE_USAGE_COMPANY_CAR_ASG_YTD');

3160: end if;
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:

Line 3196: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');

3192: end if;
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');

Line 3200: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_LIFE_SAVINGS_CONTRIBUTION_ASG_YTD');

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

Line 3233: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('CHILD_CARE_EMPLOYER_CONTRIBUTION_ASG_YTD');

3229: end if;
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:

Line 3265: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('PAID_DISABILITY_ALLOWANCE_ASG_YTD');

3261: end if;
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:

Line 3297: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');

3293: end if;
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');

Line 3301: /* l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_LIFE_CYCLE_LEAVE_DISCOUNT_ASG_YTD');

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);
3303: l_Applied_LCLD:=l_Applied_LCLD + l_balance_value;*/
3304:
3305: hr_utility.set_location('l_Applied_LCLD'||l_Applied_LCLD,425);