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 833: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SI_INCOME_STANDARD_TAX_ASG_YTD');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

988: end if;
989:
990:
991:
992: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_ZVW_CONTRIBUTION_SPECIAL_TAX_ASG_YTD');
993: IF l_context_id IS NULL then
994: l_balance_value:=0;
995: ELSE
996: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

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

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

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

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

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

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

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

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

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

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

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

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

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

1084: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1085: end if;
1086:
1087:
1088: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1089: IF l_context_id IS NULL then
1090: l_balance_value:=0;
1091: ELSE
1092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

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

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

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

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

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

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

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

1136: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1137: end if;
1138:
1139:
1140: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1141: IF l_context_id IS NULL then
1142: l_balance_value:=0;
1143: ELSE
1144: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWE',null,null);

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

1153: hr_utility.set_location('l_sum_of_balances'||l_sum_of_balances,425);
1154: end if;
1155:
1156:
1157: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1158: IF l_context_id IS NULL then
1159: l_balance_value:=0;
1160: ELSE
1161: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'WEWA',null,null);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1403: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_SPECIAL_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_SPECIAL_TAX_DEDUCTION_ASG_YTD');
1404: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1405: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1406:
1407:

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

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

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

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

Line 1442: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('SPECIAL_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('SPECIAL_TAX_CORRECTION_ASG_YTD');
1443: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1444: l_wt_and_ni_cont:= l_wt_and_ni_cont + l_balance_value;
1445:
1446:

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

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

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

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

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

1542: l_context_id:=get_context_id('SOURCE_TEXT');
1543:
1544:
1545:
1546: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1547: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1548: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1549:
1550:

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

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

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

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

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

1583: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1584: end if;
1585:
1586:
1587: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_PRIVATE_HEALTH_CONTRIBUTION_ASG_YTD');
1588: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1589: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1590:
1591:

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

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

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

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

Line 1627: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_SPECIAL_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_SPECIAL_TAX_ASG_YTD');
1628: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1629: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1630:
1631:

Line 1640: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_IZA_CONTRIBUTION_NON_TAXABLE_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_NON_TAXABLE_ASG_YTD');
1641: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1642: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1643:
1644:

Line 1653: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_IZA_CONTRIBUTION_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('RETRO_EMPLOYEE_IZA_CONTRIBUTION_ASG_YTD');
1654: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1655: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1656:
1657:

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

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

Line 1679: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_IZA_CONTRIBUTION_SPECIAL_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_SPECIAL_TAX_ASG_YTD');
1680: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id);
1681: l_ZFW_PHI_Contribution:=l_ZFW_PHI_Contribution + l_balance_value;
1682:
1683:

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

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

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

1701: end if;
1702:
1703:
1704:
1705: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1706: IF l_context_id IS NULL then
1707: l_balance_value:=0;
1708: ELSE
1709: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

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

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

1736: end if;
1737:
1738:
1739:
1740: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1741: IF l_context_id IS NULL then
1742: l_balance_value:=0;
1743: ELSE
1744: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1754: end if;
1755:
1756:
1757:
1758: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1759: IF l_context_id IS NULL then
1760: l_balance_value:=0;
1761: ELSE
1762: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1772: end if;
1773:
1774:
1775:
1776: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1777: IF l_context_id IS NULL then
1778: l_balance_value:=0;
1779: ELSE
1780: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

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

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

1808: end if;
1809:
1810:
1811:
1812: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1813: IF l_context_id IS NULL then
1814: l_balance_value:=0;
1815: ELSE
1816: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1826: end if;
1827:
1828:
1829:
1830: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1831: IF l_context_id IS NULL then
1832: l_balance_value:=0;
1833: ELSE
1834: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1842: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1843: end if;
1844:
1845:
1846: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
1847: IF l_context_id IS NULL then
1848: l_balance_value:=0;
1849: ELSE
1850: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

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

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

1878: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1879: end if;
1880:
1881:
1882: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1883: IF l_context_id IS NULL then
1884: l_balance_value:=0;
1885: ELSE
1886: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1896: end if;
1897:
1898:
1899:
1900: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1901: IF l_context_id IS NULL then
1902: l_balance_value:=0;
1903: ELSE
1904: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1913: hr_utility.set_location('l_ZFW_PHI_Contribution'||l_ZFW_PHI_Contribution,425);
1914: end if;
1915:
1916:
1917: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_ASG_SIT_YTD');
1918: IF l_context_id IS NULL then
1919: l_balance_value:=0;
1920: ELSE
1921: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

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

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

1949: end if;
1950:
1951:
1952:
1953: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
1954: IF l_context_id IS NULL then
1955: l_balance_value:=0;
1956: ELSE
1957: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

1967: end if;
1968:
1969:
1970:
1971: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYER_SI_CONTRIBUTION_NON_TAXABLE_ASG_SIT_YTD');
1972: IF l_context_id IS NULL then
1973: l_balance_value:=0;
1974: ELSE
1975: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZFW',null,null);

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

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

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

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

Line 2063: 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');

2059: OPEN csr_run_result_id(csr_tax_year_assgn_act_id_rec.assignment_action_id,l_element_type_id);
2060: FETCH csr_run_result_id into l_run_result_id;
2061: CLOSE csr_run_result_id;
2062:
2063: 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');
2064:
2065: IF substr (l_run_result_value, 1, 2) = '01' OR
2066: substr (l_run_result_value, 3, 2) = '01' OR
2067: substr (l_run_result_value, 5, 2) = '01' OR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2998:
2999: l_context_id:=get_context_id('SOURCE_TEXT');
3000:
3001:
3002: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('NET_EMPLOYEE_SI_CONTRIBUTION_ASG_SIT_YTD');
3003: IF l_context_id IS NULL then
3004: l_balance_value:=0;
3005: ELSE
3006: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

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

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

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

3033: end if;
3034:
3035:
3036:
3037: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
3038: IF l_context_id IS NULL then
3039: l_balance_value:=0;
3040: ELSE
3041: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

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

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

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

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

Line 3088: l_defined_balance_id:=pay_nl_general.get_defined_balance_id('RETRO_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_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_EMPLOYEE_SI_CONTRIBUTION_SPECIAL_TAX_ASG_SIT_YTD');
3089: IF l_context_id IS NULL then
3090: l_balance_value:=0;
3091: ELSE
3092: l_balance_value:=pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id,null,null,l_context_id,'ZVW',null,null);

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

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

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

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

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

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

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

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

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

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

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

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

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

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