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_US_ACTION_ARCH dependencies on PAY_US_ACTION_ARCH

Line 1: PACKAGE BODY pay_us_action_arch AS

1: PACKAGE BODY pay_us_action_arch AS
2: /* $Header: pyusxfrp.pkb 120.15.12010000.4 2008/09/27 09:13:06 sudedas ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_action_arch

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_action_arch
21:
22: Description : This procedure is used by the External Process
23: Archive process to archive the Employee and
24: Employer Balances in pay_action_information table.

Line 265: gv_package VARCHAR2(100) := 'pay_us_action_arch';

261:
262: /******************************************************************************
263: ** Package Local Variables
264: ******************************************************************************/
265: gv_package VARCHAR2(100) := 'pay_us_action_arch';
266: gn_gross_earn_def_bal_id number := 0;
267: gn_payments_def_bal_id number := 0;
268:
269: /***************************************************************************

Line 1089: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category

1085:
1086: ln_fed_count := ln_fed_count + 1;
1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1088:
1089: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1090: := 'US FEDERAL';
1091: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1092: := lv_balance_name;
1093: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

Line 1091: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

1087: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1088:
1089: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1090: := 'US FEDERAL';
1091: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1092: := lv_balance_name;
1093: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1094: := ln_balance_type_id;
1095:

Line 1093: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

1089: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1090: := 'US FEDERAL';
1091: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1092: := lv_balance_name;
1093: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1094: := ln_balance_type_id;
1095:
1096: if lv_balance_name in ('Supplemental Earnings for FIT',
1097: 'Supplemental Earnings for NWFIT',

Line 1109: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1105: 'Supplemental Earnings for EIC',
1106: 'Pre Tax Deductions for EIC') then
1107:
1108: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1109: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1110: := get_defined_balance_id(ln_business_group_id,
1111: lv_balance_name,
1112: lv_subj_pymt_dimension);
1113:

Line 1114: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1110: := get_defined_balance_id(ln_business_group_id,
1111: lv_balance_name,
1112: lv_subj_pymt_dimension);
1113:
1114: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1115: := get_defined_balance_id(ln_business_group_id,
1116: lv_balance_name,
1117: '_SUBJECT_TO_TAX_ASG_GRE_RUN');
1118:

Line 1119: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1115: := get_defined_balance_id(ln_business_group_id,
1116: lv_balance_name,
1117: '_SUBJECT_TO_TAX_ASG_GRE_RUN');
1118:
1119: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1120: := get_defined_balance_id(ln_business_group_id,
1121: lv_balance_name,
1122: '_SUBJECT_TO_TAX_ASG_GRE_YTD');
1123:

Line 1127: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1123:
1124: else
1125: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1126: hr_utility.trace('lv_pymt_dimension = '||lv_pymt_dimension);
1127: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1128: := get_defined_balance_id(ln_business_group_id,
1129: lv_balance_name,
1130: lv_pymt_dimension);
1131:

Line 1132: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1128: := get_defined_balance_id(ln_business_group_id,
1129: lv_balance_name,
1130: lv_pymt_dimension);
1131:
1132: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1133: := get_defined_balance_id(ln_business_group_id,
1134: lv_balance_name,
1135: '_ASG_GRE_RUN');
1136:

Line 1137: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1133: := get_defined_balance_id(ln_business_group_id,
1134: lv_balance_name,
1135: '_ASG_GRE_RUN');
1136:
1137: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1138: := get_defined_balance_id(ln_business_group_id,
1139: lv_balance_name,
1140: '_ASG_GRE_YTD');
1141:

Line 1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category

1162:
1163: hr_utility.trace('ln_fed_count = ' || to_char(ln_fed_count));
1164: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1165:
1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1167: := 'US FEDERAL';
1168: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1169: := 'Non W2 FIT Withheld';
1170: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

Line 1168: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

1164: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1165:
1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1167: := 'US FEDERAL';
1168: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1169: := 'Non W2 FIT Withheld';
1170: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1171: := ln_balance_type_id;
1172:

Line 1170: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

1166: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1167: := 'US FEDERAL';
1168: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1169: := 'Non W2 FIT Withheld';
1170: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1171: := ln_balance_type_id;
1172:
1173: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1174: := get_defined_balance_id(ln_business_group_id,

Line 1173: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1169: := 'Non W2 FIT Withheld';
1170: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1171: := ln_balance_type_id;
1172:
1173: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1174: := get_defined_balance_id(ln_business_group_id,
1175: 'Non W2 FIT Withheld',
1176: lv_pymt_dimension);
1177:

Line 1178: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1174: := get_defined_balance_id(ln_business_group_id,
1175: 'Non W2 FIT Withheld',
1176: lv_pymt_dimension);
1177:
1178: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1179: := get_defined_balance_id(ln_business_group_id,
1180: 'Non W2 FIT Withheld',
1181: '_ASG_GRE_RUN');
1182:

Line 1183: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1179: := get_defined_balance_id(ln_business_group_id,
1180: 'Non W2 FIT Withheld',
1181: '_ASG_GRE_RUN');
1182:
1183: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1184: := get_defined_balance_id(ln_business_group_id,
1185: 'Non W2 FIT Withheld',
1186: '_ASG_GRE_YTD');
1187:

Line 1227: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category

1223: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1224:
1225: ln_state_count := ln_state_count + 1;
1226:
1227: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1228: := 'US STATE';
1229: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1230: := lv_balance_name;
1231: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

Line 1229: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name

1225: ln_state_count := ln_state_count + 1;
1226:
1227: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1228: := 'US STATE';
1229: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1230: := lv_balance_name;
1231: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1232: := ln_balance_type_id;
1233:

Line 1231: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

1227: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1228: := 'US STATE';
1229: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1230: := lv_balance_name;
1231: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1232: := ln_balance_type_id;
1233:
1234: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1235: := get_defined_balance_id(ln_business_group_id,

Line 1234: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id

1230: := lv_balance_name;
1231: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1232: := ln_balance_type_id;
1233:
1234: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1235: := get_defined_balance_id(ln_business_group_id,
1236: lv_balance_name,
1237: lv_jd_pymt_dimension);
1238:

Line 1239: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id

1235: := get_defined_balance_id(ln_business_group_id,
1236: lv_balance_name,
1237: lv_jd_pymt_dimension);
1238:
1239: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id
1240: := get_defined_balance_id(ln_business_group_id,
1241: lv_balance_name,
1242: '_ASG_JD_GRE_RUN');
1243:

Line 1244: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id

1240: := get_defined_balance_id(ln_business_group_id,
1241: lv_balance_name,
1242: '_ASG_JD_GRE_RUN');
1243:
1244: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id
1245: := get_defined_balance_id(ln_business_group_id,
1246: lv_balance_name,
1247: '_ASG_JD_GRE_YTD');
1248:

Line 1269: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category

1265: loop
1266: ln_balance_type_id := c_rec.balance_type_id;
1267: end loop;
1268:
1269: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1270: := 'US STATE';
1271: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1272: := 'SIT Alien Withheld';
1273: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

Line 1271: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name

1267: end loop;
1268:
1269: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1270: := 'US STATE';
1271: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1272: := 'SIT Alien Withheld';
1273: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1274: := ln_balance_type_id;
1275:

Line 1273: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

1269: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1270: := 'US STATE';
1271: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1272: := 'SIT Alien Withheld';
1273: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1274: := ln_balance_type_id;
1275:
1276: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1277: := get_defined_balance_id(ln_business_group_id,

Line 1276: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id

1272: := 'SIT Alien Withheld';
1273: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1274: := ln_balance_type_id;
1275:
1276: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1277: := get_defined_balance_id(ln_business_group_id,
1278: 'SIT Alien Withheld',
1279: lv_jd_pymt_dimension);
1280:

Line 1281: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id

1277: := get_defined_balance_id(ln_business_group_id,
1278: 'SIT Alien Withheld',
1279: lv_jd_pymt_dimension);
1280:
1281: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id
1282: := get_defined_balance_id(ln_business_group_id,
1283: 'SIT Alien Withheld',
1284: '_ASG_JD_GRE_RUN');
1285:

Line 1286: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id

1282: := get_defined_balance_id(ln_business_group_id,
1283: 'SIT Alien Withheld',
1284: '_ASG_JD_GRE_RUN');
1285:
1286: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id
1287: := get_defined_balance_id(ln_business_group_id,
1288: 'SIT Alien Withheld',
1289: '_ASG_JD_GRE_YTD');
1290:

Line 1311: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category

1307: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1308:
1309: ln_county_count := ln_county_count + 1;
1310:
1311: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1312: := 'US COUNTY';
1313: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1314: := lv_balance_name;
1315: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id

Line 1313: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name

1309: ln_county_count := ln_county_count + 1;
1310:
1311: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1312: := 'US COUNTY';
1313: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1314: := lv_balance_name;
1315: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1316: := ln_balance_type_id;
1317:

Line 1315: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id

1311: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1312: := 'US COUNTY';
1313: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1314: := lv_balance_name;
1315: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1316: := ln_balance_type_id;
1317:
1318: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1319: := get_defined_balance_id(ln_business_group_id,

Line 1318: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id

1314: := lv_balance_name;
1315: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1316: := ln_balance_type_id;
1317:
1318: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1319: := get_defined_balance_id(ln_business_group_id,
1320: lv_balance_name,
1321: lv_jd_pymt_dimension);
1322: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id

Line 1322: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id

1318: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1319: := get_defined_balance_id(ln_business_group_id,
1320: lv_balance_name,
1321: lv_jd_pymt_dimension);
1322: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id
1323: := get_defined_balance_id(ln_business_group_id,
1324: lv_balance_name,
1325: '_ASG_JD_GRE_RUN');
1326: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id

Line 1326: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id

1322: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id
1323: := get_defined_balance_id(ln_business_group_id,
1324: lv_balance_name,
1325: '_ASG_JD_GRE_RUN');
1326: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id
1327: := get_defined_balance_id(ln_business_group_id,
1328: lv_balance_name,
1329: '_ASG_JD_GRE_YTD');
1330:

Line 1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..

1333: close c_get_balances;
1334: --
1335: hr_utility.trace('Entering County Loop ' );
1336: ln_step := 35;
1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||

Line 1338: pay_us_action_arch.ltr_county_tax_bal.last loop

1334: --
1335: hr_utility.trace('Entering County Loop ' );
1336: ln_step := 35;
1337: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);

Line 1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);

1338: pay_us_action_arch.ltr_county_tax_bal.last loop
1339:
1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);

Line 1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);

1340: hr_utility.trace('Count = ' || to_char(i));
1341: hr_utility.trace('Category = ' ||
1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);

Line 1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);

1342: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1343: hr_utility.trace('Balance Name = ' ||
1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);

Line 1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);

1344: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1345: hr_utility.trace('pay_def_bal_id ' ||
1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1351: end loop;
1352: hr_utility.trace('Leaving County Loop ' );

Line 1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);

1346: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1347: hr_utility.trace('asg_run_def_bal_id = ' ||
1348: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1349: hr_utility.trace('ytd_def_bal_id = ' ||
1350: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1351: end loop;
1352: hr_utility.trace('Leaving County Loop ' );
1353: --
1354:

Line 1370: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category

1366: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1367:
1368: ln_city_count := ln_city_count + 1;
1369:
1370: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1371: := 'US CITY';
1372: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1373: := lv_balance_name;
1374: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id

Line 1372: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name

1368: ln_city_count := ln_city_count + 1;
1369:
1370: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1371: := 'US CITY';
1372: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1373: := lv_balance_name;
1374: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1375: := ln_balance_type_id;
1376:

Line 1374: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id

1370: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1371: := 'US CITY';
1372: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1373: := lv_balance_name;
1374: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1375: := ln_balance_type_id;
1376:
1377: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1378: := get_defined_balance_id(ln_business_group_id,

Line 1377: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id

1373: := lv_balance_name;
1374: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1375: := ln_balance_type_id;
1376:
1377: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1378: := get_defined_balance_id(ln_business_group_id,
1379: lv_balance_name,
1380: lv_jd_pymt_dimension);
1381: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id

Line 1381: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id

1377: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1378: := get_defined_balance_id(ln_business_group_id,
1379: lv_balance_name,
1380: lv_jd_pymt_dimension);
1381: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id
1382: := get_defined_balance_id(ln_business_group_id,
1383: lv_balance_name,
1384: '_ASG_JD_GRE_RUN');
1385: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id

Line 1385: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id

1381: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id
1382: := get_defined_balance_id(ln_business_group_id,
1383: lv_balance_name,
1384: '_ASG_JD_GRE_RUN');
1385: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id
1386: := get_defined_balance_id(ln_business_group_id,
1387: lv_balance_name,
1388: '_ASG_JD_GRE_YTD');
1389:

Line 1409: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category

1405: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1406:
1407: ln_schdist_count := ln_schdist_count + 1;
1408:
1409: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1410: := 'US SCHOOL DISTRICT';
1411: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1412: := lv_balance_name;
1413: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id

Line 1411: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name

1407: ln_schdist_count := ln_schdist_count + 1;
1408:
1409: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1410: := 'US SCHOOL DISTRICT';
1411: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1412: := lv_balance_name;
1413: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1414: := ln_balance_type_id;
1415:

Line 1413: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id

1409: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1410: := 'US SCHOOL DISTRICT';
1411: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1412: := lv_balance_name;
1413: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1414: := ln_balance_type_id;
1415:
1416: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1417: := get_defined_balance_id(ln_business_group_id,

Line 1416: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id

1412: := lv_balance_name;
1413: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1414: := ln_balance_type_id;
1415:
1416: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1417: := get_defined_balance_id(ln_business_group_id,
1418: lv_balance_name,
1419: lv_jd_pymt_dimension);
1420: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id

Line 1420: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id

1416: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1417: := get_defined_balance_id(ln_business_group_id,
1418: lv_balance_name,
1419: lv_jd_pymt_dimension);
1420: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id
1421: := get_defined_balance_id(ln_business_group_id,
1422: lv_balance_name,
1423: '_ASG_JD_GRE_RUN');
1424: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id

Line 1424: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id

1420: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id
1421: := get_defined_balance_id(ln_business_group_id,
1422: lv_balance_name,
1423: '_ASG_JD_GRE_RUN');
1424: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id
1425: := get_defined_balance_id(ln_business_group_id,
1426: lv_balance_name,
1427: '_ASG_JD_GRE_YTD');
1428:

Line 1435: pay_us_action_arch.ltr_fed_tax_bal.count);

1431: close c_get_balances;
1432:
1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);

Line 1437: pay_us_action_arch.ltr_state_tax_bal.count);

1433: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1434: hr_utility.trace('Fed Balance Loop Count = ' ||
1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);

Line 1439: pay_us_action_arch.ltr_county_tax_bal.count);

1435: pay_us_action_arch.ltr_fed_tax_bal.count);
1436: hr_utility.trace('State Balance Loop Count = ' ||
1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);

Line 1441: pay_us_action_arch.ltr_city_tax_bal.count);

1437: pay_us_action_arch.ltr_state_tax_bal.count);
1438: hr_utility.trace('County Balance Loop Count = ' ||
1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);
1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1445:

Line 1443: pay_us_action_arch.ltr_schdist_tax_bal.count);

1439: pay_us_action_arch.ltr_county_tax_bal.count);
1440: hr_utility.trace('City Balance Loop Count = ' ||
1441: pay_us_action_arch.ltr_city_tax_bal.count);
1442: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1443: pay_us_action_arch.ltr_schdist_tax_bal.count);
1444: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1445:
1446:
1447: /****************************************************

Line 1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists

1466: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1467: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:
1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1471: := lv_sit_exists;
1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1473: := lv_sui_ee_exists;
1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists

Line 1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists

1468: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1469:
1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1471: := lv_sit_exists;
1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1473: := lv_sui_ee_exists;
1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1475: := lv_sui_er_exists;
1476: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists

Line 1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists

1470: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1471: := lv_sit_exists;
1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1473: := lv_sui_ee_exists;
1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1475: := lv_sui_er_exists;
1476: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1477: := lv_sdi_ee_exists;
1478: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists

Line 1476: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists

1472: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1473: := lv_sui_ee_exists;
1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1475: := lv_sui_er_exists;
1476: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1477: := lv_sdi_ee_exists;
1478: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists
1479: := lv_sdi_er_exists;
1480:

Line 1478: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists

1474: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1475: := lv_sui_er_exists;
1476: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1477: := lv_sdi_ee_exists;
1478: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists
1479: := lv_sdi_er_exists;
1480:
1481: end loop;
1482: close c_get_states_jit;

Line 1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;

1495: end if;
1496: hr_utility.set_location(gv_package || lv_procedure_name, 370);
1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1498:
1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1500:
1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1502: := lv_jurisdiction_code;
1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists

Line 1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code

1497: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1498:
1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1500:
1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1502: := lv_jurisdiction_code;
1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1504: := lv_county_tax_exists;
1505: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists

Line 1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists

1499: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1500:
1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1502: := lv_jurisdiction_code;
1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1504: := lv_county_tax_exists;
1505: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1506: := lv_county_sd_tax_exists;
1507: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

Line 1505: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists

1501: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1502: := lv_jurisdiction_code;
1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1504: := lv_county_tax_exists;
1505: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1506: := lv_county_sd_tax_exists;
1507: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
1508: := lv_county_head_tax_exists;
1509:

Line 1507: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

1503: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1504: := lv_county_tax_exists;
1505: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1506: := lv_county_sd_tax_exists;
1507: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
1508: := lv_county_head_tax_exists;
1509:
1510: end loop;
1511: close c_get_county_jit;

Line 3085: for i in pay_us_action_arch.ltr_fed_tax_bal.first..

3081:
3082: ln_index := get_table_index('00-000-0000');
3083:
3084: hr_utility.trace('Fed Loop Count = ' || ln_index);
3085: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3086: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3087:
3088: lv_balance_name
3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;

Line 3086: pay_us_action_arch.ltr_fed_tax_bal.last LOOP

3082: ln_index := get_table_index('00-000-0000');
3083:
3084: hr_utility.trace('Fed Loop Count = ' || ln_index);
3085: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3086: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3087:
3088: lv_balance_name
3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3090: ln_balance_type_id

Line 3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;

3085: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3086: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3087:
3088: lv_balance_name
3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3090: ln_balance_type_id
3091: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3092: ln_pymt_def_bal_id
3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;

Line 3091: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;

3087:
3088: lv_balance_name
3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3090: ln_balance_type_id
3091: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3092: ln_pymt_def_bal_id
3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3094: ln_ytd_def_bal_id
3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;

Line 3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;

3089: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3090: ln_balance_type_id
3091: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3092: ln_pymt_def_bal_id
3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3094: ln_ytd_def_bal_id
3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3096: ln_run_def_bal_id
3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;

Line 3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;

3091: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3092: ln_pymt_def_bal_id
3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3094: ln_ytd_def_bal_id
3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3096: ln_run_def_bal_id
3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);

Line 3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;

3093: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3094: ln_ytd_def_bal_id
3095: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3096: ln_run_def_bal_id
3097: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3098:
3099: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3100: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3101: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);

Line 3328: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;

3324: lv_sdi_er_exists := 'Y';
3325: else
3326: lv_state_code := substr(p_jurisdiction_tab(i).emp_jd,1,2);
3327: lv_sit_exists
3328: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3329: lv_sui_ee_exists
3330: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3331: lv_sui_er_exists
3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;

Line 3330: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;

3326: lv_state_code := substr(p_jurisdiction_tab(i).emp_jd,1,2);
3327: lv_sit_exists
3328: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3329: lv_sui_ee_exists
3330: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3331: lv_sui_er_exists
3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3333: lv_sdi_ee_exists
3334: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;

Line 3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;

3328: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3329: lv_sui_ee_exists
3330: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3331: lv_sui_er_exists
3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3333: lv_sdi_ee_exists
3334: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3335: lv_sdi_er_exists
3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;

Line 3334: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;

3330: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3331: lv_sui_er_exists
3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3333: lv_sdi_ee_exists
3334: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3335: lv_sdi_er_exists
3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3337: end if;
3338:

Line 3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;

3332: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3333: lv_sdi_ee_exists
3334: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3335: lv_sdi_er_exists
3336: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3337: end if;
3338:
3339: hr_utility.trace('p_action_type = ' || p_action_type);
3340: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);

Line 3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then

3360: := 'US STATE';
3361: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3362: := p_jurisdiction_tab(i).emp_jd;
3363:
3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3365: --(
3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;

Line 3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..

3362: := p_jurisdiction_tab(i).emp_jd;
3363:
3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3365: --(
3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;

Line 3367: pay_us_action_arch.ltr_state_tax_bal.last loop

3363:
3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3365: --(
3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;

Line 3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;

3364: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3365: --(
3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;

Line 3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;

3365: --(
3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:

Line 3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;

3366: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;

3367: pay_us_action_arch.ltr_state_tax_bal.last loop
3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);

Line 3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;

3368: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3369: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3370: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3371: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3372: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3373:
3374: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3375: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3376: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);

Line 3714: pay_us_action_arch.ltr_county_tax_bal.count);

3710:
3711: BEGIN
3712: hr_utility.set_location(gv_package || lv_procedure_name, 10);
3713: hr_utility.trace('County Balance Loop Count = ' ||
3714: pay_us_action_arch.ltr_county_tax_bal.count);
3715:
3716: if p_jurisdiction_tab.count > 0 then
3717: for i in p_jurisdiction_tab.first..
3718: p_jurisdiction_tab.last loop

Line 3721: if pay_us_action_arch.ltr_county_tax_info.count > 0 then

3717: for i in p_jurisdiction_tab.first..
3718: p_jurisdiction_tab.last loop
3719:
3720: hr_utility.set_location(gv_package || lv_procedure_name, 160);
3721: if pay_us_action_arch.ltr_county_tax_info.count > 0 then
3722: if p_action_type = 'B' then
3723: lv_county_tax_exists := 'Y';
3724: lv_county_head_tax_exists := 'Y';
3725: else

Line 3726: for j in pay_us_action_arch.ltr_county_tax_info.first ..

3722: if p_action_type = 'B' then
3723: lv_county_tax_exists := 'Y';
3724: lv_county_head_tax_exists := 'Y';
3725: else
3726: for j in pay_us_action_arch.ltr_county_tax_info.first ..
3727: pay_us_action_arch.ltr_county_tax_info.last loop
3728: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
3729: = p_jurisdiction_tab(i).emp_jd then
3730: lv_county_tax_exists

Line 3727: pay_us_action_arch.ltr_county_tax_info.last loop

3723: lv_county_tax_exists := 'Y';
3724: lv_county_head_tax_exists := 'Y';
3725: else
3726: for j in pay_us_action_arch.ltr_county_tax_info.first ..
3727: pay_us_action_arch.ltr_county_tax_info.last loop
3728: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
3729: = p_jurisdiction_tab(i).emp_jd then
3730: lv_county_tax_exists
3731: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;

Line 3728: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code

3724: lv_county_head_tax_exists := 'Y';
3725: else
3726: for j in pay_us_action_arch.ltr_county_tax_info.first ..
3727: pay_us_action_arch.ltr_county_tax_info.last loop
3728: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
3729: = p_jurisdiction_tab(i).emp_jd then
3730: lv_county_tax_exists
3731: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
3732: lv_county_head_tax_exists

Line 3731: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;

3727: pay_us_action_arch.ltr_county_tax_info.last loop
3728: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
3729: = p_jurisdiction_tab(i).emp_jd then
3730: lv_county_tax_exists
3731: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
3732: lv_county_head_tax_exists
3733: := pay_us_action_arch.ltr_county_tax_info(j).cnty_head_tax_exists;
3734: exit;
3735: end if;

Line 3733: := pay_us_action_arch.ltr_county_tax_info(j).cnty_head_tax_exists;

3729: = p_jurisdiction_tab(i).emp_jd then
3730: lv_county_tax_exists
3731: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
3732: lv_county_head_tax_exists
3733: := pay_us_action_arch.ltr_county_tax_info(j).cnty_head_tax_exists;
3734: exit;
3735: end if;
3736: end loop;
3737: end if;

Line 3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then

3760: else
3761: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3762: end if;
3763:
3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;

Line 3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..

3761: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3762: end if;
3763:
3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;

Line 3766: pay_us_action_arch.ltr_county_tax_bal.last loop

3762: end if;
3763:
3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;

Line 3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;

3763:
3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;

Line 3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;

3764: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:

Line 3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;

3765: for k in pay_us_action_arch.ltr_county_tax_bal.first..
3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);

Line 3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;

3766: pay_us_action_arch.ltr_county_tax_bal.last loop
3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);

Line 3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;

3767: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
3768: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
3769: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
3770: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
3771: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
3772:
3773: hr_utility.trace('lv_balance_name = '||lv_balance_name);
3774: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
3775: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

Line 3958: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then

3954: else
3955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3956: end if;
3957:
3958: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..
3960: pay_us_action_arch.ltr_city_tax_bal.last loop
3961:
3962: lv_balance_name :=

Line 3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..

3955: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
3956: end if;
3957:
3958: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..
3960: pay_us_action_arch.ltr_city_tax_bal.last loop
3961:
3962: lv_balance_name :=
3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;

Line 3960: pay_us_action_arch.ltr_city_tax_bal.last loop

3956: end if;
3957:
3958: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..
3960: pay_us_action_arch.ltr_city_tax_bal.last loop
3961:
3962: lv_balance_name :=
3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
3964: ln_balance_type_id :=

Line 3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;

3959: for k in pay_us_action_arch.ltr_city_tax_bal.first..
3960: pay_us_action_arch.ltr_city_tax_bal.last loop
3961:
3962: lv_balance_name :=
3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
3964: ln_balance_type_id :=
3965: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
3966: ln_pymt_def_bal_id :=
3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;

Line 3965: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;

3961:
3962: lv_balance_name :=
3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
3964: ln_balance_type_id :=
3965: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
3966: ln_pymt_def_bal_id :=
3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
3968: ln_ytd_def_bal_id :=
3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;

Line 3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;

3963: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
3964: ln_balance_type_id :=
3965: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
3966: ln_pymt_def_bal_id :=
3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
3968: ln_ytd_def_bal_id :=
3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
3970: ln_run_def_bal_id :=
3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;

Line 3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;

3965: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
3966: ln_pymt_def_bal_id :=
3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
3968: ln_ytd_def_bal_id :=
3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
3970: ln_run_def_bal_id :=
3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);

Line 3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;

3967: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
3968: ln_ytd_def_bal_id :=
3969: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
3970: ln_run_def_bal_id :=
3971: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
3972:
3973: hr_utility.trace('lv_balance_name ='||lv_balance_name);
3974: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
3975: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);

Line 4130: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then

4126: := 'US SCHOOL DISTRICT';
4127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
4128: := p_jurisdiction_tab(j).emp_parent_jd;
4129:
4130: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
4132: pay_us_action_arch.ltr_schdist_tax_bal.last loop
4133:
4134: lv_balance_name

Line 4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..

4127: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
4128: := p_jurisdiction_tab(j).emp_parent_jd;
4129:
4130: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
4132: pay_us_action_arch.ltr_schdist_tax_bal.last loop
4133:
4134: lv_balance_name
4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;

Line 4132: pay_us_action_arch.ltr_schdist_tax_bal.last loop

4128: := p_jurisdiction_tab(j).emp_parent_jd;
4129:
4130: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
4132: pay_us_action_arch.ltr_schdist_tax_bal.last loop
4133:
4134: lv_balance_name
4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
4136: ln_balance_type_id

Line 4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;

4131: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
4132: pay_us_action_arch.ltr_schdist_tax_bal.last loop
4133:
4134: lv_balance_name
4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
4136: ln_balance_type_id
4137: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
4138: ln_pymt_def_bal_id
4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;

Line 4137: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;

4133:
4134: lv_balance_name
4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
4136: ln_balance_type_id
4137: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
4138: ln_pymt_def_bal_id
4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
4140: ln_ytd_def_bal_id
4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;

Line 4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;

4135: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
4136: ln_balance_type_id
4137: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
4138: ln_pymt_def_bal_id
4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
4140: ln_ytd_def_bal_id
4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
4142: ln_run_def_bal_id
4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;

Line 4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;

4137: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
4138: ln_pymt_def_bal_id
4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
4140: ln_ytd_def_bal_id
4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
4142: ln_run_def_bal_id
4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);

Line 4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;

4139: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
4140: ln_ytd_def_bal_id
4141: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
4142: ln_run_def_bal_id
4143: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
4144:
4145: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4146: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
4147: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

Line 6372: end pay_us_action_arch;

6368:
6369: --begin
6370: --hr_utility.trace_on (null, 'XFR');
6371:
6372: end pay_us_action_arch;