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.34.12020000.11 2013/05/03 09:06:05 pkoduri 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 350: gv_package VARCHAR2(100) := 'pay_us_action_arch';

346:
347: /******************************************************************************
348: ** Package Local Variables
349: ******************************************************************************/
350: gv_package VARCHAR2(100) := 'pay_us_action_arch';
351: gn_gross_earn_def_bal_id number := 0;
352: gn_payments_def_bal_id number := 0;
353:
354: /***************************************************************************

Line 1248: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category

1244:
1245: ln_fed_count := ln_fed_count + 1;
1246: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1247:
1248: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1249: := 'US FEDERAL';
1250: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1251: := lv_balance_name;
1252: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

Line 1250: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

1246: hr_utility.trace('ln_fed_count = '||ln_fed_count);
1247:
1248: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1249: := 'US FEDERAL';
1250: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1251: := lv_balance_name;
1252: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1253: := ln_balance_type_id;
1254:

Line 1252: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

1248: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1249: := 'US FEDERAL';
1250: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1251: := lv_balance_name;
1252: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1253: := ln_balance_type_id;
1254:
1255: if lv_balance_name in ('Supplemental Earnings for FIT',
1256: 'Supplemental Earnings for NWFIT',

Line 1268: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1264: 'Supplemental Earnings for EIC',
1265: 'Pre Tax Deductions for EIC') then
1266:
1267: hr_utility.set_location(gv_package || lv_procedure_name, 50);
1268: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1269: := get_defined_balance_id(ln_business_group_id,
1270: lv_balance_name,
1271: lv_subj_pymt_dimension);
1272:

Line 1273: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1269: := get_defined_balance_id(ln_business_group_id,
1270: lv_balance_name,
1271: lv_subj_pymt_dimension);
1272:
1273: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1274: := get_defined_balance_id(ln_business_group_id,
1275: lv_balance_name,
1276: '_SUBJECT_TO_TAX_ASG_GRE_RUN');
1277:

Line 1278: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1274: := get_defined_balance_id(ln_business_group_id,
1275: lv_balance_name,
1276: '_SUBJECT_TO_TAX_ASG_GRE_RUN');
1277:
1278: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1279: := get_defined_balance_id(ln_business_group_id,
1280: lv_balance_name,
1281: '_SUBJECT_TO_TAX_ASG_GRE_YTD');
1282:

Line 1286: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1282:
1283: else
1284: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1285: hr_utility.trace('lv_pymt_dimension = '||lv_pymt_dimension);
1286: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1287: := get_defined_balance_id(ln_business_group_id,
1288: lv_balance_name,
1289: lv_pymt_dimension);
1290:

Line 1291: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1287: := get_defined_balance_id(ln_business_group_id,
1288: lv_balance_name,
1289: lv_pymt_dimension);
1290:
1291: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1292: := get_defined_balance_id(ln_business_group_id,
1293: lv_balance_name,
1294: '_ASG_GRE_RUN');
1295:

Line 1296: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1292: := get_defined_balance_id(ln_business_group_id,
1293: lv_balance_name,
1294: '_ASG_GRE_RUN');
1295:
1296: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1297: := get_defined_balance_id(ln_business_group_id,
1298: lv_balance_name,
1299: '_ASG_GRE_YTD');
1300:

Line 1325: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category

1321:
1322: hr_utility.trace('ln_fed_count = ' || to_char(ln_fed_count));
1323: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1324:
1325: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1326: := 'US FEDERAL';
1327: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1328: := 'Non W2 FIT Withheld';
1329: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

Line 1327: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name

1323: hr_utility.trace('ln_blance_type_id = ' || to_char(ln_balance_type_id));
1324:
1325: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1326: := 'US FEDERAL';
1327: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1328: := 'Non W2 FIT Withheld';
1329: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1330: := ln_balance_type_id;
1331:

Line 1329: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id

1325: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).action_info_category
1326: := 'US FEDERAL';
1327: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_name
1328: := 'Non W2 FIT Withheld';
1329: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1330: := ln_balance_type_id;
1331:
1332: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1333: := get_defined_balance_id(ln_business_group_id,

Line 1332: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id

1328: := 'Non W2 FIT Withheld';
1329: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).balance_type_id
1330: := ln_balance_type_id;
1331:
1332: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).payment_def_bal_id
1333: := get_defined_balance_id(ln_business_group_id,
1334: 'Non W2 FIT Withheld',
1335: lv_pymt_dimension);
1336:

Line 1337: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id

1333: := get_defined_balance_id(ln_business_group_id,
1334: 'Non W2 FIT Withheld',
1335: lv_pymt_dimension);
1336:
1337: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).asg_run_def_bal_id
1338: := get_defined_balance_id(ln_business_group_id,
1339: 'Non W2 FIT Withheld',
1340: '_ASG_GRE_RUN');
1341:

Line 1342: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id

1338: := get_defined_balance_id(ln_business_group_id,
1339: 'Non W2 FIT Withheld',
1340: '_ASG_GRE_RUN');
1341:
1342: pay_us_action_arch.ltr_fed_tax_bal(ln_fed_count).ytd_def_bal_id
1343: := get_defined_balance_id(ln_business_group_id,
1344: 'Non W2 FIT Withheld',
1345: '_ASG_GRE_YTD');
1346:

Line 1386: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category

1382: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1383:
1384: ln_state_count := ln_state_count + 1;
1385:
1386: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1387: := 'US STATE';
1388: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1389: := lv_balance_name;
1390: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

Line 1388: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name

1384: ln_state_count := ln_state_count + 1;
1385:
1386: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1387: := 'US STATE';
1388: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1389: := lv_balance_name;
1390: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1391: := ln_balance_type_id;
1392:

Line 1390: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

1386: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1387: := 'US STATE';
1388: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1389: := lv_balance_name;
1390: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1391: := ln_balance_type_id;
1392:
1393: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1394: := get_defined_balance_id(ln_business_group_id,

Line 1393: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id

1389: := lv_balance_name;
1390: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1391: := ln_balance_type_id;
1392:
1393: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1394: := get_defined_balance_id(ln_business_group_id,
1395: lv_balance_name,
1396: lv_jd_pymt_dimension);
1397:

Line 1398: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id

1394: := get_defined_balance_id(ln_business_group_id,
1395: lv_balance_name,
1396: lv_jd_pymt_dimension);
1397:
1398: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id
1399: := get_defined_balance_id(ln_business_group_id,
1400: lv_balance_name,
1401: '_ASG_JD_GRE_RUN');
1402:

Line 1403: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id

1399: := get_defined_balance_id(ln_business_group_id,
1400: lv_balance_name,
1401: '_ASG_JD_GRE_RUN');
1402:
1403: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id
1404: := get_defined_balance_id(ln_business_group_id,
1405: lv_balance_name,
1406: '_ASG_JD_GRE_YTD');
1407:

Line 1414: /* NOTE The pay_us_action_arch.ltr_state2_tax_bal table is different.

1410: close c_get_balances;
1411:
1412:
1413: -- TCL_SUI1 begin
1414: /* NOTE The pay_us_action_arch.ltr_state2_tax_bal table is different.
1415: specifically ltr_state2_tax_bal a table structure for STATE2 */
1416: /* Get State Balances context 2*/
1417: ln_step := 23;
1418: open c_get_balances('US STATE2');

Line 1430: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).action_info_category

1426: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1427:
1428: ln_state2_count := ln_state2_count + 1;
1429:
1430: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).action_info_category
1431: := 'US STATE2';
1432: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_name
1433: := lv_balance_name;
1434: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_type_id

Line 1432: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_name

1428: ln_state2_count := ln_state2_count + 1;
1429:
1430: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).action_info_category
1431: := 'US STATE2';
1432: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_name
1433: := lv_balance_name;
1434: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_type_id
1435: := ln_balance_type_id;
1436:

Line 1434: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_type_id

1430: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).action_info_category
1431: := 'US STATE2';
1432: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_name
1433: := lv_balance_name;
1434: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_type_id
1435: := ln_balance_type_id;
1436:
1437: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).payment_def_bal_id
1438: := get_defined_balance_id(ln_business_group_id,

Line 1437: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).payment_def_bal_id

1433: := lv_balance_name;
1434: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).balance_type_id
1435: := ln_balance_type_id;
1436:
1437: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).payment_def_bal_id
1438: := get_defined_balance_id(ln_business_group_id,
1439: lv_balance_name,
1440: lv_jd_pymt_dimension);
1441:

Line 1442: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).asg_run_def_bal_id

1438: := get_defined_balance_id(ln_business_group_id,
1439: lv_balance_name,
1440: lv_jd_pymt_dimension);
1441:
1442: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).asg_run_def_bal_id
1443: := get_defined_balance_id(ln_business_group_id,
1444: lv_balance_name,
1445: '_ASG_JD_GRE_RUN');
1446:

Line 1447: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).ytd_def_bal_id

1443: := get_defined_balance_id(ln_business_group_id,
1444: lv_balance_name,
1445: '_ASG_JD_GRE_RUN');
1446:
1447: pay_us_action_arch.ltr_state2_tax_bal(ln_state2_count).ytd_def_bal_id
1448: := get_defined_balance_id(ln_business_group_id,
1449: lv_balance_name,
1450: '_ASG_JD_GRE_YTD');
1451:

Line 1474: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category

1470: loop
1471: ln_balance_type_id := c_rec.balance_type_id;
1472: end loop;
1473:
1474: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1475: := 'US STATE';
1476: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1477: := 'SIT Alien Withheld';
1478: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

Line 1476: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name

1472: end loop;
1473:
1474: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1475: := 'US STATE';
1476: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1477: := 'SIT Alien Withheld';
1478: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1479: := ln_balance_type_id;
1480:

Line 1478: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id

1474: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).action_info_category
1475: := 'US STATE';
1476: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_name
1477: := 'SIT Alien Withheld';
1478: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1479: := ln_balance_type_id;
1480:
1481: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1482: := get_defined_balance_id(ln_business_group_id,

Line 1481: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id

1477: := 'SIT Alien Withheld';
1478: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).balance_type_id
1479: := ln_balance_type_id;
1480:
1481: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).payment_def_bal_id
1482: := get_defined_balance_id(ln_business_group_id,
1483: 'SIT Alien Withheld',
1484: lv_jd_pymt_dimension);
1485:

Line 1486: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id

1482: := get_defined_balance_id(ln_business_group_id,
1483: 'SIT Alien Withheld',
1484: lv_jd_pymt_dimension);
1485:
1486: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).asg_run_def_bal_id
1487: := get_defined_balance_id(ln_business_group_id,
1488: 'SIT Alien Withheld',
1489: '_ASG_JD_GRE_RUN');
1490:

Line 1491: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id

1487: := get_defined_balance_id(ln_business_group_id,
1488: 'SIT Alien Withheld',
1489: '_ASG_JD_GRE_RUN');
1490:
1491: pay_us_action_arch.ltr_state_tax_bal(ln_state_count).ytd_def_bal_id
1492: := get_defined_balance_id(ln_business_group_id,
1493: 'SIT Alien Withheld',
1494: '_ASG_JD_GRE_YTD');
1495:

Line 1516: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category

1512: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1513:
1514: ln_county_count := ln_county_count + 1;
1515:
1516: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1517: := 'US COUNTY';
1518: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1519: := lv_balance_name;
1520: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id

Line 1518: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name

1514: ln_county_count := ln_county_count + 1;
1515:
1516: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1517: := 'US COUNTY';
1518: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1519: := lv_balance_name;
1520: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1521: := ln_balance_type_id;
1522:

Line 1520: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id

1516: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).action_info_category
1517: := 'US COUNTY';
1518: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_name
1519: := lv_balance_name;
1520: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1521: := ln_balance_type_id;
1522:
1523: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1524: := get_defined_balance_id(ln_business_group_id,

Line 1523: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id

1519: := lv_balance_name;
1520: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).balance_type_id
1521: := ln_balance_type_id;
1522:
1523: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1524: := get_defined_balance_id(ln_business_group_id,
1525: lv_balance_name,
1526: lv_jd_pymt_dimension);
1527: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id

Line 1527: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id

1523: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).payment_def_bal_id
1524: := get_defined_balance_id(ln_business_group_id,
1525: lv_balance_name,
1526: lv_jd_pymt_dimension);
1527: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id
1528: := get_defined_balance_id(ln_business_group_id,
1529: lv_balance_name,
1530: '_ASG_JD_GRE_RUN');
1531: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id

Line 1531: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id

1527: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).asg_run_def_bal_id
1528: := get_defined_balance_id(ln_business_group_id,
1529: lv_balance_name,
1530: '_ASG_JD_GRE_RUN');
1531: pay_us_action_arch.ltr_county_tax_bal(ln_county_count).ytd_def_bal_id
1532: := get_defined_balance_id(ln_business_group_id,
1533: lv_balance_name,
1534: '_ASG_JD_GRE_YTD');
1535:

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

1538: close c_get_balances;
1539: --
1540: hr_utility.trace('Entering County Loop ' );
1541: ln_step := 35;
1542: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1543: pay_us_action_arch.ltr_county_tax_bal.last loop
1544:
1545: hr_utility.trace('Count = ' || to_char(i));
1546: hr_utility.trace('Category = ' ||

Line 1543: pay_us_action_arch.ltr_county_tax_bal.last loop

1539: --
1540: hr_utility.trace('Entering County Loop ' );
1541: ln_step := 35;
1542: for i in pay_us_action_arch.ltr_county_tax_bal.first ..
1543: pay_us_action_arch.ltr_county_tax_bal.last loop
1544:
1545: hr_utility.trace('Count = ' || to_char(i));
1546: hr_utility.trace('Category = ' ||
1547: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);

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

1543: pay_us_action_arch.ltr_county_tax_bal.last loop
1544:
1545: hr_utility.trace('Count = ' || to_char(i));
1546: hr_utility.trace('Category = ' ||
1547: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1548: hr_utility.trace('Balance Name = ' ||
1549: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1550: hr_utility.trace('pay_def_bal_id ' ||
1551: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);

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

1545: hr_utility.trace('Count = ' || to_char(i));
1546: hr_utility.trace('Category = ' ||
1547: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1548: hr_utility.trace('Balance Name = ' ||
1549: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1550: hr_utility.trace('pay_def_bal_id ' ||
1551: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1552: hr_utility.trace('asg_run_def_bal_id = ' ||
1553: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);

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

1547: pay_us_action_arch.ltr_county_tax_bal(i).action_info_category);
1548: hr_utility.trace('Balance Name = ' ||
1549: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1550: hr_utility.trace('pay_def_bal_id ' ||
1551: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1552: hr_utility.trace('asg_run_def_bal_id = ' ||
1553: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1554: hr_utility.trace('ytd_def_bal_id = ' ||
1555: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);

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

1549: pay_us_action_arch.ltr_county_tax_bal(i).balance_name);
1550: hr_utility.trace('pay_def_bal_id ' ||
1551: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1552: hr_utility.trace('asg_run_def_bal_id = ' ||
1553: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1554: hr_utility.trace('ytd_def_bal_id = ' ||
1555: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1556: end loop;
1557: hr_utility.trace('Leaving County Loop ' );

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

1551: pay_us_action_arch.ltr_county_tax_bal(i).payment_def_bal_id);
1552: hr_utility.trace('asg_run_def_bal_id = ' ||
1553: pay_us_action_arch.ltr_county_tax_bal(i).asg_run_def_bal_id);
1554: hr_utility.trace('ytd_def_bal_id = ' ||
1555: pay_us_action_arch.ltr_county_tax_bal(i).ytd_def_bal_id);
1556: end loop;
1557: hr_utility.trace('Leaving County Loop ' );
1558: --
1559:

Line 1575: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category

1571: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1572:
1573: ln_city_count := ln_city_count + 1;
1574:
1575: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1576: := 'US CITY';
1577: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1578: := lv_balance_name;
1579: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id

Line 1577: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name

1573: ln_city_count := ln_city_count + 1;
1574:
1575: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1576: := 'US CITY';
1577: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1578: := lv_balance_name;
1579: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1580: := ln_balance_type_id;
1581:

Line 1579: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id

1575: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).action_info_category
1576: := 'US CITY';
1577: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_name
1578: := lv_balance_name;
1579: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1580: := ln_balance_type_id;
1581:
1582: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1583: := get_defined_balance_id(ln_business_group_id,

Line 1582: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id

1578: := lv_balance_name;
1579: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).balance_type_id
1580: := ln_balance_type_id;
1581:
1582: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1583: := get_defined_balance_id(ln_business_group_id,
1584: lv_balance_name,
1585: lv_jd_pymt_dimension);
1586: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id

Line 1586: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id

1582: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).payment_def_bal_id
1583: := get_defined_balance_id(ln_business_group_id,
1584: lv_balance_name,
1585: lv_jd_pymt_dimension);
1586: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id
1587: := get_defined_balance_id(ln_business_group_id,
1588: lv_balance_name,
1589: '_ASG_JD_GRE_RUN');
1590: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id

Line 1590: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id

1586: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).asg_run_def_bal_id
1587: := get_defined_balance_id(ln_business_group_id,
1588: lv_balance_name,
1589: '_ASG_JD_GRE_RUN');
1590: pay_us_action_arch.ltr_city_tax_bal(ln_city_count).ytd_def_bal_id
1591: := get_defined_balance_id(ln_business_group_id,
1592: lv_balance_name,
1593: '_ASG_JD_GRE_YTD');
1594:

Line 1614: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category

1610: hr_utility.trace('lv_balance_name is '||lv_balance_name);
1611:
1612: ln_schdist_count := ln_schdist_count + 1;
1613:
1614: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1615: := 'US SCHOOL DISTRICT';
1616: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1617: := lv_balance_name;
1618: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id

Line 1616: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name

1612: ln_schdist_count := ln_schdist_count + 1;
1613:
1614: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1615: := 'US SCHOOL DISTRICT';
1616: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1617: := lv_balance_name;
1618: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1619: := ln_balance_type_id;
1620:

Line 1618: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id

1614: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).action_info_category
1615: := 'US SCHOOL DISTRICT';
1616: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_name
1617: := lv_balance_name;
1618: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1619: := ln_balance_type_id;
1620:
1621: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1622: := get_defined_balance_id(ln_business_group_id,

Line 1621: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id

1617: := lv_balance_name;
1618: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).balance_type_id
1619: := ln_balance_type_id;
1620:
1621: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1622: := get_defined_balance_id(ln_business_group_id,
1623: lv_balance_name,
1624: lv_jd_pymt_dimension);
1625: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id

Line 1625: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id

1621: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).payment_def_bal_id
1622: := get_defined_balance_id(ln_business_group_id,
1623: lv_balance_name,
1624: lv_jd_pymt_dimension);
1625: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id
1626: := get_defined_balance_id(ln_business_group_id,
1627: lv_balance_name,
1628: '_ASG_JD_GRE_RUN');
1629: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id

Line 1629: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id

1625: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).asg_run_def_bal_id
1626: := get_defined_balance_id(ln_business_group_id,
1627: lv_balance_name,
1628: '_ASG_JD_GRE_RUN');
1629: pay_us_action_arch.ltr_schdist_tax_bal(ln_schdist_count).ytd_def_bal_id
1630: := get_defined_balance_id(ln_business_group_id,
1631: lv_balance_name,
1632: '_ASG_JD_GRE_YTD');
1633:

Line 1651: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).action_info_category

1647: hr_utility.set_location(gv_package || lv_procedure_name, 180);
1648:
1649: ln_psd_count := ln_psd_count + 1;
1650:
1651: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).action_info_category
1652: := 'US PSD';
1653: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_name
1654: := lv_balance_name;
1655:

Line 1653: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_name

1649: ln_psd_count := ln_psd_count + 1;
1650:
1651: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).action_info_category
1652: := 'US PSD';
1653: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_name
1654: := lv_balance_name;
1655:
1656:
1657: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_type_id

Line 1657: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_type_id

1653: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_name
1654: := lv_balance_name;
1655:
1656:
1657: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_type_id
1658: := ln_balance_type_id;
1659:
1660:
1661: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).payment_def_bal_id

Line 1661: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).payment_def_bal_id

1657: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).balance_type_id
1658: := ln_balance_type_id;
1659:
1660:
1661: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).payment_def_bal_id
1662: := get_defined_balance_id(ln_business_group_id,
1663: lv_balance_name,
1664: lv_jd_pymt_dimension);
1665:

Line 1670: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id

1666:
1667: IF instr(lv_balance_name, 'YTD') = 0 THEN
1668:
1669:
1670: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id
1671: := get_defined_balance_id(ln_business_group_id,
1672: lv_balance_name,
1673: '_ASG_JD_GRE_RUN');
1674: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id

Line 1674: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id

1670: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id
1671: := get_defined_balance_id(ln_business_group_id,
1672: lv_balance_name,
1673: '_ASG_JD_GRE_RUN');
1674: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id
1675: := NULL;
1676: ELSE
1677:
1678: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id

Line 1678: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id

1674: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id
1675: := NULL;
1676: ELSE
1677:
1678: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id
1679: := NULL;
1680: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id
1681: := get_defined_balance_id(ln_business_group_id,
1682: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'YTD')-2)),

Line 1680: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id

1676: ELSE
1677:
1678: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).asg_run_def_bal_id
1679: := NULL;
1680: pay_us_action_arch.ltr_psd_tax_bal(ln_psd_count).ytd_def_bal_id
1681: := get_defined_balance_id(ln_business_group_id,
1682: substr(lv_balance_name, 1 , (instr(lv_balance_name, 'YTD')-2)),
1683: '_ASG_JD_GRE_YTD');
1684: END IF;

Line 1707: pay_us_action_arch.ltr_fed_tax_bal.count);

1703:
1704:
1705: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1706: hr_utility.trace('Fed Balance Loop Count = ' ||
1707: pay_us_action_arch.ltr_fed_tax_bal.count);
1708: hr_utility.trace('State Balance Loop Count = ' ||
1709: pay_us_action_arch.ltr_state_tax_bal.count);
1710: hr_utility.trace('County Balance Loop Count = ' ||
1711: pay_us_action_arch.ltr_county_tax_bal.count);

Line 1709: pay_us_action_arch.ltr_state_tax_bal.count);

1705: hr_utility.set_location(gv_package || lv_procedure_name, 240);
1706: hr_utility.trace('Fed Balance Loop Count = ' ||
1707: pay_us_action_arch.ltr_fed_tax_bal.count);
1708: hr_utility.trace('State Balance Loop Count = ' ||
1709: pay_us_action_arch.ltr_state_tax_bal.count);
1710: hr_utility.trace('County Balance Loop Count = ' ||
1711: pay_us_action_arch.ltr_county_tax_bal.count);
1712: hr_utility.trace('City Balance Loop Count = ' ||
1713: pay_us_action_arch.ltr_city_tax_bal.count);

Line 1711: pay_us_action_arch.ltr_county_tax_bal.count);

1707: pay_us_action_arch.ltr_fed_tax_bal.count);
1708: hr_utility.trace('State Balance Loop Count = ' ||
1709: pay_us_action_arch.ltr_state_tax_bal.count);
1710: hr_utility.trace('County Balance Loop Count = ' ||
1711: pay_us_action_arch.ltr_county_tax_bal.count);
1712: hr_utility.trace('City Balance Loop Count = ' ||
1713: pay_us_action_arch.ltr_city_tax_bal.count);
1714: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1715: pay_us_action_arch.ltr_schdist_tax_bal.count);

Line 1713: pay_us_action_arch.ltr_city_tax_bal.count);

1709: pay_us_action_arch.ltr_state_tax_bal.count);
1710: hr_utility.trace('County Balance Loop Count = ' ||
1711: pay_us_action_arch.ltr_county_tax_bal.count);
1712: hr_utility.trace('City Balance Loop Count = ' ||
1713: pay_us_action_arch.ltr_city_tax_bal.count);
1714: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1715: pay_us_action_arch.ltr_schdist_tax_bal.count);
1716: hr_utility.trace('PSD Balance Loop Count = ' ||
1717: pay_us_action_arch.ltr_psd_tax_bal.count);

Line 1715: pay_us_action_arch.ltr_schdist_tax_bal.count);

1711: pay_us_action_arch.ltr_county_tax_bal.count);
1712: hr_utility.trace('City Balance Loop Count = ' ||
1713: pay_us_action_arch.ltr_city_tax_bal.count);
1714: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1715: pay_us_action_arch.ltr_schdist_tax_bal.count);
1716: hr_utility.trace('PSD Balance Loop Count = ' ||
1717: pay_us_action_arch.ltr_psd_tax_bal.count);
1718:
1719: hr_utility.set_location(gv_package || lv_procedure_name, 250);

Line 1717: pay_us_action_arch.ltr_psd_tax_bal.count);

1713: pay_us_action_arch.ltr_city_tax_bal.count);
1714: hr_utility.trace('School Dsts Balance Loop Count = ' ||
1715: pay_us_action_arch.ltr_schdist_tax_bal.count);
1716: hr_utility.trace('PSD Balance Loop Count = ' ||
1717: pay_us_action_arch.ltr_psd_tax_bal.count);
1718:
1719: hr_utility.set_location(gv_package || lv_procedure_name, 250);
1720:
1721:

Line 1745: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists

1741: hr_utility.trace('lv_sui_er_exists = ' || lv_sui_er_exists);
1742: hr_utility.trace('lv_sdi_ee_exists = ' || lv_sdi_ee_exists);
1743: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1744:
1745: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1746: := lv_sit_exists;
1747: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1748: := lv_sui_ee_exists;
1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists

Line 1747: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists

1743: hr_utility.trace('lv_sdi_er_exists = ' || lv_sdi_er_exists);
1744:
1745: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1746: := lv_sit_exists;
1747: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1748: := lv_sui_ee_exists;
1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1750: := lv_sui_er_exists;
1751: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists

Line 1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists

1745: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists
1746: := lv_sit_exists;
1747: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1748: := lv_sui_ee_exists;
1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1750: := lv_sui_er_exists;
1751: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1752: := lv_sdi_ee_exists;
1753: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists

Line 1751: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists

1747: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists
1748: := lv_sui_ee_exists;
1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1750: := lv_sui_er_exists;
1751: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1752: := lv_sdi_ee_exists;
1753: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists
1754: := lv_sdi_er_exists;
1755:

Line 1753: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists

1749: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists
1750: := lv_sui_er_exists;
1751: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists
1752: := lv_sdi_ee_exists;
1753: pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists
1754: := lv_sdi_er_exists;
1755:
1756: end loop;
1757: close c_get_states_jit;

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

1770: end if;
1771: hr_utility.set_location(gv_package || lv_procedure_name, 370);
1772: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1773:
1774: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1775:
1776: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1777: := lv_jurisdiction_code;
1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists

Line 1776: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code

1772: hr_utility.trace('lv_jurisdiction_code = ' || lv_jurisdiction_code);
1773:
1774: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1775:
1776: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1777: := lv_jurisdiction_code;
1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1779: := lv_county_tax_exists;
1780: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists

Line 1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists

1774: ln_index := pay_us_action_arch.ltr_county_tax_info.count;
1775:
1776: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1777: := lv_jurisdiction_code;
1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1779: := lv_county_tax_exists;
1780: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1781: := lv_county_sd_tax_exists;
1782: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

Line 1780: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists

1776: pay_us_action_arch.ltr_county_tax_info(ln_index).jurisdiction_code
1777: := lv_jurisdiction_code;
1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1779: := lv_county_tax_exists;
1780: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1781: := lv_county_sd_tax_exists;
1782: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
1783: := lv_county_head_tax_exists;
1784:

Line 1782: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

1778: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_tax_exists
1779: := lv_county_tax_exists;
1780: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_head_tax_exists
1781: := lv_county_sd_tax_exists;
1782: pay_us_action_arch.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
1783: := lv_county_head_tax_exists;
1784:
1785: end loop;
1786: close c_get_county_jit;

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

3668: ln_index := get_table_index('00-000-0000',
3669: NULL);
3670:
3671: hr_utility.trace('Fed Loop Count = ' || ln_index);
3672: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3673: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3674:
3675: lv_balance_name
3676: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;

Line 3673: pay_us_action_arch.ltr_fed_tax_bal.last LOOP

3669: NULL);
3670:
3671: hr_utility.trace('Fed Loop Count = ' || ln_index);
3672: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3673: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3674:
3675: lv_balance_name
3676: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3677: ln_balance_type_id

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

3672: for i in pay_us_action_arch.ltr_fed_tax_bal.first..
3673: pay_us_action_arch.ltr_fed_tax_bal.last LOOP
3674:
3675: lv_balance_name
3676: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3677: ln_balance_type_id
3678: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3679: ln_pymt_def_bal_id
3680: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;

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

3674:
3675: lv_balance_name
3676: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3677: ln_balance_type_id
3678: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3679: ln_pymt_def_bal_id
3680: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3681: ln_ytd_def_bal_id
3682: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;

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

3676: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_name;
3677: ln_balance_type_id
3678: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3679: ln_pymt_def_bal_id
3680: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3681: ln_ytd_def_bal_id
3682: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3683: ln_run_def_bal_id
3684: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;

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

3678: := pay_us_action_arch.ltr_fed_tax_bal(i).balance_type_id;
3679: ln_pymt_def_bal_id
3680: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3681: ln_ytd_def_bal_id
3682: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3683: ln_run_def_bal_id
3684: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3685:
3686: hr_utility.trace('lv_balance_name = ' || lv_balance_name);

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

3680: := pay_us_action_arch.ltr_fed_tax_bal(i).payment_def_bal_id;
3681: ln_ytd_def_bal_id
3682: := pay_us_action_arch.ltr_fed_tax_bal(i).ytd_def_bal_id;
3683: ln_run_def_bal_id
3684: := pay_us_action_arch.ltr_fed_tax_bal(i).asg_run_def_bal_id;
3685:
3686: hr_utility.trace('lv_balance_name = ' || lv_balance_name);
3687: hr_utility.trace('ln_pymt_def_bal_id = ' || ln_pymt_def_bal_id);
3688: hr_utility.trace('ln_ytd_def_bal_id = ' || ln_ytd_def_bal_id);

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

3911: lv_sdi_er_exists := 'Y';
3912: else
3913: lv_state_code := substr(p_jurisdiction_tab(i).emp_jd,1,2);
3914: lv_sit_exists
3915: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3916: lv_sui_ee_exists
3917: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3918: lv_sui_er_exists
3919: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;

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

3913: lv_state_code := substr(p_jurisdiction_tab(i).emp_jd,1,2);
3914: lv_sit_exists
3915: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3916: lv_sui_ee_exists
3917: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3918: lv_sui_er_exists
3919: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3920: lv_sdi_ee_exists
3921: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;

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

3915: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sit_exists;
3916: lv_sui_ee_exists
3917: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3918: lv_sui_er_exists
3919: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3920: lv_sdi_ee_exists
3921: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3922: lv_sdi_er_exists
3923: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;

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

3917: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_ee_exists;
3918: lv_sui_er_exists
3919: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3920: lv_sdi_ee_exists
3921: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3922: lv_sdi_er_exists
3923: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3924: end if;
3925:

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

3919: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sui_er_exists;
3920: lv_sdi_ee_exists
3921: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_ee_exists;
3922: lv_sdi_er_exists
3923: := pay_us_action_arch.ltr_state_tax_info(lv_state_code).sdi_er_exists;
3924: end if;
3925:
3926: hr_utility.trace('p_action_type = ' || p_action_type);
3927: hr_utility.trace('lv_sit_exists = ' || lv_sit_exists);

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

3948: := 'US STATE';
3949: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
3950: := p_jurisdiction_tab(i).emp_jd;
3951:
3952: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3953: --(
3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;

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

3950: := p_jurisdiction_tab(i).emp_jd;
3951:
3952: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3953: --(
3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;

Line 3955: pay_us_action_arch.ltr_state_tax_bal.last loop

3951:
3952: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3953: --(
3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;

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

3952: if pay_us_action_arch.ltr_state_tax_bal.count > 0 then
3953: --(
3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3960: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;

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

3953: --(
3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3960: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3961:

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

3954: for j in pay_us_action_arch.ltr_state_tax_bal.first..
3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3960: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3961:
3962: hr_utility.trace('lv_balance_name =' || lv_balance_name);

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

3955: pay_us_action_arch.ltr_state_tax_bal.last loop
3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3960: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3961:
3962: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3963: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);

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

3956: lv_balance_name := pay_us_action_arch.ltr_state_tax_bal(j).balance_name;
3957: ln_balance_type_id := pay_us_action_arch.ltr_state_tax_bal(j).balance_type_id;
3958: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).payment_def_bal_id;
3959: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).ytd_def_bal_id;
3960: ln_run_def_bal_id := pay_us_action_arch.ltr_state_tax_bal(j).asg_run_def_bal_id;
3961:
3962: hr_utility.trace('lv_balance_name =' || lv_balance_name);
3963: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
3964: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);

Line 4266: if pay_us_action_arch.ltr_state2_tax_bal.count > 0 then

4262: := 'US STATE2';
4263: pay_ac_action_arch.lrr_act_tab(ln_index).jurisdiction_code
4264: := p_jurisdiction_tab(i).emp_jd;
4265:
4266: if pay_us_action_arch.ltr_state2_tax_bal.count > 0 then
4267: --(
4268: hr_utility.trace('US STATE2 for J... ');
4269:
4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..

Line 4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..

4266: if pay_us_action_arch.ltr_state2_tax_bal.count > 0 then
4267: --(
4268: hr_utility.trace('US STATE2 for J... ');
4269:
4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..
4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;

Line 4271: pay_us_action_arch.ltr_state2_tax_bal.last loop

4267: --(
4268: hr_utility.trace('US STATE2 for J... ');
4269:
4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..
4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;

Line 4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;

4268: hr_utility.trace('US STATE2 for J... ');
4269:
4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..
4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;
4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;

Line 4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;

4269:
4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..
4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;
4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;
4277:

Line 4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;

4270: for j in pay_us_action_arch.ltr_state2_tax_bal.first..
4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;
4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;
4277:
4278: hr_utility.trace('lv_balance_name =' || lv_balance_name);

Line 4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;

4271: pay_us_action_arch.ltr_state2_tax_bal.last loop
4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;
4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;
4277:
4278: hr_utility.trace('lv_balance_name =' || lv_balance_name);
4279: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);

Line 4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;

4272: lv_balance_name := pay_us_action_arch.ltr_state2_tax_bal(j).balance_name;
4273: ln_balance_type_id := pay_us_action_arch.ltr_state2_tax_bal(j).balance_type_id;
4274: ln_pymt_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).payment_def_bal_id;
4275: ln_ytd_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).ytd_def_bal_id;
4276: ln_run_def_bal_id := pay_us_action_arch.ltr_state2_tax_bal(j).asg_run_def_bal_id;
4277:
4278: hr_utility.trace('lv_balance_name =' || lv_balance_name);
4279: hr_utility.trace('ln_pymt_def_bal_id=' || ln_pymt_def_bal_id);
4280: hr_utility.trace('ln_ytd_def_bal_id =' || ln_ytd_def_bal_id);

Line 4480: pay_us_action_arch.ltr_county_tax_bal.count);

4476:
4477: BEGIN
4478: hr_utility.set_location(gv_package || lv_procedure_name, 10);
4479: hr_utility.trace('County Balance Loop Count = ' ||
4480: pay_us_action_arch.ltr_county_tax_bal.count);
4481:
4482: if p_jurisdiction_tab.count > 0 then
4483: for i in p_jurisdiction_tab.first..
4484: p_jurisdiction_tab.last loop

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

4483: for i in p_jurisdiction_tab.first..
4484: p_jurisdiction_tab.last loop
4485:
4486: hr_utility.set_location(gv_package || lv_procedure_name, 160);
4487: if pay_us_action_arch.ltr_county_tax_info.count > 0 then
4488: if p_action_type = 'B' then
4489: lv_county_tax_exists := 'Y';
4490: lv_county_head_tax_exists := 'Y';
4491: else

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

4488: if p_action_type = 'B' then
4489: lv_county_tax_exists := 'Y';
4490: lv_county_head_tax_exists := 'Y';
4491: else
4492: for j in pay_us_action_arch.ltr_county_tax_info.first ..
4493: pay_us_action_arch.ltr_county_tax_info.last loop
4494: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
4495: = p_jurisdiction_tab(i).emp_jd then
4496: lv_county_tax_exists

Line 4493: pay_us_action_arch.ltr_county_tax_info.last loop

4489: lv_county_tax_exists := 'Y';
4490: lv_county_head_tax_exists := 'Y';
4491: else
4492: for j in pay_us_action_arch.ltr_county_tax_info.first ..
4493: pay_us_action_arch.ltr_county_tax_info.last loop
4494: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
4495: = p_jurisdiction_tab(i).emp_jd then
4496: lv_county_tax_exists
4497: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;

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

4490: lv_county_head_tax_exists := 'Y';
4491: else
4492: for j in pay_us_action_arch.ltr_county_tax_info.first ..
4493: pay_us_action_arch.ltr_county_tax_info.last loop
4494: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
4495: = p_jurisdiction_tab(i).emp_jd then
4496: lv_county_tax_exists
4497: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
4498: lv_county_head_tax_exists

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

4493: pay_us_action_arch.ltr_county_tax_info.last loop
4494: if pay_us_action_arch.ltr_county_tax_info(j).jurisdiction_code
4495: = p_jurisdiction_tab(i).emp_jd then
4496: lv_county_tax_exists
4497: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
4498: lv_county_head_tax_exists
4499: := pay_us_action_arch.ltr_county_tax_info(j).cnty_head_tax_exists;
4500: exit;
4501: end if;

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

4495: = p_jurisdiction_tab(i).emp_jd then
4496: lv_county_tax_exists
4497: := pay_us_action_arch.ltr_county_tax_info(j).cnty_tax_exists;
4498: lv_county_head_tax_exists
4499: := pay_us_action_arch.ltr_county_tax_info(j).cnty_head_tax_exists;
4500: exit;
4501: end if;
4502: end loop;
4503: end if;

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

4527: else
4528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4529: end if;
4530:
4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;

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

4528: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4529: end if;
4530:
4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;

Line 4533: pay_us_action_arch.ltr_county_tax_bal.last loop

4529: end if;
4530:
4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;

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

4530:
4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
4538: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;

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

4531: if pay_us_action_arch.ltr_county_tax_bal.count > 0 then
4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
4538: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
4539:

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

4532: for k in pay_us_action_arch.ltr_county_tax_bal.first..
4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
4538: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
4539:
4540: hr_utility.trace('lv_balance_name = '||lv_balance_name);

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

4533: pay_us_action_arch.ltr_county_tax_bal.last loop
4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
4538: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
4539:
4540: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4541: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);

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

4534: lv_balance_name := pay_us_action_arch.ltr_county_tax_bal(k).balance_name;
4535: ln_balance_type_id := pay_us_action_arch.ltr_county_tax_bal(k).balance_type_id;
4536: ln_pymt_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).payment_def_bal_id;
4537: ln_ytd_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).ytd_def_bal_id;
4538: ln_run_def_bal_id := pay_us_action_arch.ltr_county_tax_bal(k).asg_run_def_bal_id;
4539:
4540: hr_utility.trace('lv_balance_name = '||lv_balance_name);
4541: hr_utility.trace('ln_pymt_def_bal_id = '||ln_pymt_def_bal_id);
4542: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

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

4722: else
4723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4724: end if;
4725:
4726: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
4727: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4728: pay_us_action_arch.ltr_city_tax_bal.last loop
4729:
4730: lv_balance_name :=

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

4723: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4724: end if;
4725:
4726: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
4727: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4728: pay_us_action_arch.ltr_city_tax_bal.last loop
4729:
4730: lv_balance_name :=
4731: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;

Line 4728: pay_us_action_arch.ltr_city_tax_bal.last loop

4724: end if;
4725:
4726: if pay_us_action_arch.ltr_city_tax_bal.count > 0 then
4727: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4728: pay_us_action_arch.ltr_city_tax_bal.last loop
4729:
4730: lv_balance_name :=
4731: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
4732: ln_balance_type_id :=

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

4727: for k in pay_us_action_arch.ltr_city_tax_bal.first..
4728: pay_us_action_arch.ltr_city_tax_bal.last loop
4729:
4730: lv_balance_name :=
4731: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
4732: ln_balance_type_id :=
4733: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
4734: ln_pymt_def_bal_id :=
4735: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;

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

4729:
4730: lv_balance_name :=
4731: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
4732: ln_balance_type_id :=
4733: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
4734: ln_pymt_def_bal_id :=
4735: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
4736: ln_ytd_def_bal_id :=
4737: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;

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

4731: pay_us_action_arch.ltr_city_tax_bal(k).balance_name;
4732: ln_balance_type_id :=
4733: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
4734: ln_pymt_def_bal_id :=
4735: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
4736: ln_ytd_def_bal_id :=
4737: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
4738: ln_run_def_bal_id :=
4739: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;

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

4733: pay_us_action_arch.ltr_city_tax_bal(k).balance_type_id;
4734: ln_pymt_def_bal_id :=
4735: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
4736: ln_ytd_def_bal_id :=
4737: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
4738: ln_run_def_bal_id :=
4739: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
4740:
4741: hr_utility.trace('lv_balance_name ='||lv_balance_name);

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

4735: pay_us_action_arch.ltr_city_tax_bal(k).payment_def_bal_id;
4736: ln_ytd_def_bal_id :=
4737: pay_us_action_arch.ltr_city_tax_bal(k).ytd_def_bal_id;
4738: ln_run_def_bal_id :=
4739: pay_us_action_arch.ltr_city_tax_bal(k).asg_run_def_bal_id;
4740:
4741: hr_utility.trace('lv_balance_name ='||lv_balance_name);
4742: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
4743: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);

Line 4926: if pay_us_action_arch.ltr_psd_tax_bal.count > 0 then

4922: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30 := 'NR';
4923: end if;
4924:
4925:
4926: if pay_us_action_arch.ltr_psd_tax_bal.count > 0 then
4927: for k in pay_us_action_arch.ltr_psd_tax_bal.first..
4928: pay_us_action_arch.ltr_psd_tax_bal.last loop
4929:
4930: lv_balance_name :=

Line 4927: for k in pay_us_action_arch.ltr_psd_tax_bal.first..

4923: end if;
4924:
4925:
4926: if pay_us_action_arch.ltr_psd_tax_bal.count > 0 then
4927: for k in pay_us_action_arch.ltr_psd_tax_bal.first..
4928: pay_us_action_arch.ltr_psd_tax_bal.last loop
4929:
4930: lv_balance_name :=
4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;

Line 4928: pay_us_action_arch.ltr_psd_tax_bal.last loop

4924:
4925:
4926: if pay_us_action_arch.ltr_psd_tax_bal.count > 0 then
4927: for k in pay_us_action_arch.ltr_psd_tax_bal.first..
4928: pay_us_action_arch.ltr_psd_tax_bal.last loop
4929:
4930: lv_balance_name :=
4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;
4932: ln_balance_type_id :=

Line 4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;

4927: for k in pay_us_action_arch.ltr_psd_tax_bal.first..
4928: pay_us_action_arch.ltr_psd_tax_bal.last loop
4929:
4930: lv_balance_name :=
4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;
4932: ln_balance_type_id :=
4933: pay_us_action_arch.ltr_psd_tax_bal(k).balance_type_id;
4934: ln_pymt_def_bal_id :=
4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;

Line 4933: pay_us_action_arch.ltr_psd_tax_bal(k).balance_type_id;

4929:
4930: lv_balance_name :=
4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;
4932: ln_balance_type_id :=
4933: pay_us_action_arch.ltr_psd_tax_bal(k).balance_type_id;
4934: ln_pymt_def_bal_id :=
4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;
4936: ln_ytd_def_bal_id :=
4937: pay_us_action_arch.ltr_psd_tax_bal(k).ytd_def_bal_id;

Line 4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;

4931: pay_us_action_arch.ltr_psd_tax_bal(k).balance_name;
4932: ln_balance_type_id :=
4933: pay_us_action_arch.ltr_psd_tax_bal(k).balance_type_id;
4934: ln_pymt_def_bal_id :=
4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;
4936: ln_ytd_def_bal_id :=
4937: pay_us_action_arch.ltr_psd_tax_bal(k).ytd_def_bal_id;
4938: ln_run_def_bal_id :=
4939: pay_us_action_arch.ltr_psd_tax_bal(k).asg_run_def_bal_id;

Line 4937: pay_us_action_arch.ltr_psd_tax_bal(k).ytd_def_bal_id;

4933: pay_us_action_arch.ltr_psd_tax_bal(k).balance_type_id;
4934: ln_pymt_def_bal_id :=
4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;
4936: ln_ytd_def_bal_id :=
4937: pay_us_action_arch.ltr_psd_tax_bal(k).ytd_def_bal_id;
4938: ln_run_def_bal_id :=
4939: pay_us_action_arch.ltr_psd_tax_bal(k).asg_run_def_bal_id;
4940:
4941: hr_utility.trace('lv_balance_name ='||lv_balance_name);

Line 4939: pay_us_action_arch.ltr_psd_tax_bal(k).asg_run_def_bal_id;

4935: pay_us_action_arch.ltr_psd_tax_bal(k).payment_def_bal_id;
4936: ln_ytd_def_bal_id :=
4937: pay_us_action_arch.ltr_psd_tax_bal(k).ytd_def_bal_id;
4938: ln_run_def_bal_id :=
4939: pay_us_action_arch.ltr_psd_tax_bal(k).asg_run_def_bal_id;
4940:
4941: hr_utility.trace('lv_balance_name ='||lv_balance_name);
4942: hr_utility.trace('ln_pymt_def_bal_id='||ln_pymt_def_bal_id);
4943: hr_utility.trace('ln_ytd_def_bal_id ='||ln_ytd_def_bal_id);

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

5065: := 'US SCHOOL DISTRICT';
5066: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
5067: := p_jurisdiction_tab(j).emp_parent_jd;
5068:
5069: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
5070: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
5071: pay_us_action_arch.ltr_schdist_tax_bal.last loop
5072:
5073: lv_balance_name

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

5066: pay_ac_action_arch.lrr_act_tab(ln_index).act_info30
5067: := p_jurisdiction_tab(j).emp_parent_jd;
5068:
5069: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
5070: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
5071: pay_us_action_arch.ltr_schdist_tax_bal.last loop
5072:
5073: lv_balance_name
5074: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;

Line 5071: pay_us_action_arch.ltr_schdist_tax_bal.last loop

5067: := p_jurisdiction_tab(j).emp_parent_jd;
5068:
5069: if pay_us_action_arch.ltr_schdist_tax_bal.count > 0 then
5070: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
5071: pay_us_action_arch.ltr_schdist_tax_bal.last loop
5072:
5073: lv_balance_name
5074: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
5075: ln_balance_type_id

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

5070: for k in pay_us_action_arch.ltr_schdist_tax_bal.first..
5071: pay_us_action_arch.ltr_schdist_tax_bal.last loop
5072:
5073: lv_balance_name
5074: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
5075: ln_balance_type_id
5076: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
5077: ln_pymt_def_bal_id
5078: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;

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

5072:
5073: lv_balance_name
5074: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
5075: ln_balance_type_id
5076: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
5077: ln_pymt_def_bal_id
5078: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
5079: ln_ytd_def_bal_id
5080: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;

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

5074: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_name;
5075: ln_balance_type_id
5076: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
5077: ln_pymt_def_bal_id
5078: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
5079: ln_ytd_def_bal_id
5080: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
5081: ln_run_def_bal_id
5082: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;

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

5076: := pay_us_action_arch.ltr_schdist_tax_bal(k).balance_type_id;
5077: ln_pymt_def_bal_id
5078: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
5079: ln_ytd_def_bal_id
5080: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
5081: ln_run_def_bal_id
5082: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
5083:
5084: hr_utility.trace('lv_balance_name = '||lv_balance_name);

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

5078: := pay_us_action_arch.ltr_schdist_tax_bal(k).payment_def_bal_id;
5079: ln_ytd_def_bal_id
5080: := pay_us_action_arch.ltr_schdist_tax_bal(k).ytd_def_bal_id;
5081: ln_run_def_bal_id
5082: := pay_us_action_arch.ltr_schdist_tax_bal(k).asg_run_def_bal_id;
5083:
5084: hr_utility.trace('lv_balance_name = '||lv_balance_name);
5085: hr_utility.trace('ln_pymt_def_bal_id= '||ln_pymt_def_bal_id);
5086: hr_utility.trace('ln_ytd_def_bal_id = '||ln_ytd_def_bal_id);

Line 8433: end pay_us_action_arch;

8429:
8430: --begin
8431: --hr_utility.trace_on (null, 'XFR');
8432:
8433: end pay_us_action_arch;