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_YEAR_END_EXTRACT dependencies on HR_DIRBAL

Line 64: aparkes 19-Jan-1998 Used GB Balance direct call package hr_dirbal

60: logic is altered to check for this rule
61: first before locating run result value,
62: then defaulting to element (non- U.R.R.)
63: value as before.
64: aparkes 19-Jan-1998 Used GB Balance direct call package hr_dirbal
65: for balance fetching.
66: arundell 30-Mar-1998 Fixed bug 639910. Adjusted the way the last
67: assignment_action_id, previous_year_asg_action_id
68: and the last tax_run_result_id is derived, so

Line 1285: l_niy := 100 * hr_dirbal.get_balance(l_people.PREVIOUS_YEAR_ASG_ACTION_ID,

1281: -- get the NI Y balance for each person
1282: if l_people.PREVIOUS_YEAR_ASG_ACTION_ID is not null then -- [ LY_ACTION
1283: hr_utility.trace( 'PREVIOUS_YEAR_ASG_ACTION_ID:'||
1284: l_people.PREVIOUS_YEAR_ASG_ACTION_ID);
1285: l_niy := 100 * hr_dirbal.get_balance(l_people.PREVIOUS_YEAR_ASG_ACTION_ID,
1286: l_niy_id);
1287: l_count := l_count + 1;
1288: end if; -- ] LY_ACTION
1289: --

Line 1298: l_niy := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_niy_ly_id);

1294: if l_niy = 0 and l_people.LAST_ASG_ACTION_ID is not null
1295: and ( l_people.termination_type is null
1296: or l_people.termination_type = 'L' ) then -- [
1297: -- get the NI Y Last Year balance
1298: l_niy := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_niy_ly_id);
1299: l_count := l_count + 1;
1300: end if; -- ]
1301: --
1302: -- delete rows for last year that have no NI Y

Line 1339: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_tot_id);

1335: -- get the NI A Total Balance
1336: l_ni_tot := 0;
1337: l_ni_ees := 0;
1338: l_ni_able := 0;
1339: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_tot_id);
1340: l_count := l_count + 1;
1341: -- if there is a total get the NI A and Able Balance
1342: if l_ni_tot <> 0 then -- [ A total exists
1343: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_id);

Line 1343: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_id);

1339: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_tot_id);
1340: l_count := l_count + 1;
1341: -- if there is a total get the NI A and Able Balance
1342: if l_ni_tot <> 0 then -- [ A total exists
1343: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_id);
1344: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_able_id);
1345: l_count := l_count + 2;
1346: -- populate year end values
1347: insert into pay_gb_year_end_values

Line 1344: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_able_id);

1340: l_count := l_count + 1;
1341: -- if there is a total get the NI A and Able Balance
1342: if l_ni_tot <> 0 then -- [ A total exists
1343: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_id);
1344: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nia_able_id);
1345: l_count := l_count + 2;
1346: -- populate year end values
1347: insert into pay_gb_year_end_values
1348: (ASSIGNMENT_ID,EFFECTIVE_END_DATE,NI_CATEGORY_CODE, REPORTABLE,

Line 1365: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_tot_id);

1361: if l_people.sex = 'F' then -- [ cat B for Females only
1362: l_ni_tot := 0;
1363: l_ni_ees := 0;
1364: l_ni_able := 0;
1365: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_tot_id);
1366: l_count := l_count + 1;
1367: -- if there is a total get the NI B and Able Balance
1368: if l_ni_tot <> 0 then -- [ B Total Exists
1369: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_id);

Line 1369: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_id);

1365: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_tot_id);
1366: l_count := l_count + 1;
1367: -- if there is a total get the NI B and Able Balance
1368: if l_ni_tot <> 0 then -- [ B Total Exists
1369: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_id);
1370: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_able_id);
1371: l_count := l_count + 2;
1372: -- populate year end values
1373: insert into pay_gb_year_end_values

Line 1370: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_able_id);

1366: l_count := l_count + 1;
1367: -- if there is a total get the NI B and Able Balance
1368: if l_ni_tot <> 0 then -- [ B Total Exists
1369: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_id);
1370: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nib_able_id);
1371: l_count := l_count + 2;
1372: -- populate year end values
1373: insert into pay_gb_year_end_values
1374: (ASSIGNMENT_ID,EFFECTIVE_END_DATE,NI_CATEGORY_CODE, REPORTABLE,

Line 1389: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nic_tot_id);

1385: end if; -- ] cat B for Females only
1386: -- populate NI C rows
1387: l_ni_tot := 0;
1388: -- get the NI C Total Balance
1389: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nic_tot_id);
1390: l_count := l_count + 1;
1391: -- populate year end values
1392: if l_ni_tot <> 0 then -- [ C Total exists
1393: insert into pay_gb_year_end_values

Line 1411: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_tot_id);

1407: l_ni_able := 0;
1408: l_ni_co_able := 0;
1409: l_ni_co := 0;
1410: --
1411: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_tot_id);
1412: l_count := l_count + 1;
1413: -- if there is a total get the NI D , CO and Able Balance
1414: if l_ni_tot <> 0 then -- [ D Total exists
1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);

Line 1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);

1411: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_tot_id);
1412: l_count := l_count + 1;
1413: -- if there is a total get the NI D , CO and Able Balance
1414: if l_ni_tot <> 0 then -- [ D Total exists
1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);
1416: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_able_id);
1417: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_able_id);
1418: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_id);
1419: l_count := l_count + 4;

Line 1416: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_able_id);

1412: l_count := l_count + 1;
1413: -- if there is a total get the NI D , CO and Able Balance
1414: if l_ni_tot <> 0 then -- [ D Total exists
1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);
1416: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_able_id);
1417: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_able_id);
1418: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_id);
1419: l_count := l_count + 4;
1420: -- populate year end values

Line 1417: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_able_id);

1413: -- if there is a total get the NI D , CO and Able Balance
1414: if l_ni_tot <> 0 then -- [ D Total exists
1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);
1416: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_able_id);
1417: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_able_id);
1418: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_id);
1419: l_count := l_count + 4;
1420: -- populate year end values
1421: insert into pay_gb_year_end_values

Line 1418: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_id);

1414: if l_ni_tot <> 0 then -- [ D Total exists
1415: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_id);
1416: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_able_id);
1417: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_able_id);
1418: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nid_co_id);
1419: l_count := l_count + 4;
1420: -- populate year end values
1421: insert into pay_gb_year_end_values
1422: (ASSIGNMENT_ID,EFFECTIVE_END_DATE,NI_CATEGORY_CODE, REPORTABLE,

Line 1444: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_tot_id);

1440: l_ni_ees := 0;
1441: l_ni_able := 0;
1442: l_ni_co_able := 0;
1443: l_ni_co := 0;
1444: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_tot_id);
1445: l_count := l_count + 1;
1446: -- if there is a total get the NI E , CO and Able Balance
1447: if l_ni_tot <> 0 then -- [ E Total exists
1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);

Line 1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);

1444: l_ni_tot := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_tot_id);
1445: l_count := l_count + 1;
1446: -- if there is a total get the NI E , CO and Able Balance
1447: if l_ni_tot <> 0 then -- [ E Total exists
1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);
1449: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_able_id);
1450: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_able_id);
1451: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_id);
1452: l_count := l_count + 4;

Line 1449: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_able_id);

1445: l_count := l_count + 1;
1446: -- if there is a total get the NI E , CO and Able Balance
1447: if l_ni_tot <> 0 then -- [ E Total exists
1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);
1449: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_able_id);
1450: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_able_id);
1451: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_id);
1452: l_count := l_count + 4;
1453: -- populate year end values

Line 1450: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_able_id);

1446: -- if there is a total get the NI E , CO and Able Balance
1447: if l_ni_tot <> 0 then -- [ E Total exists
1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);
1449: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_able_id);
1450: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_able_id);
1451: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_id);
1452: l_count := l_count + 4;
1453: -- populate year end values
1454: insert into pay_gb_year_end_values

Line 1451: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_id);

1447: if l_ni_tot <> 0 then -- [ E Total exists
1448: l_ni_ees := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_id);
1449: l_ni_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_able_id);
1450: l_ni_co_able := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_able_id);
1451: l_ni_co := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nie_co_id);
1452: l_count := l_count + 4;
1453: -- populate year end values
1454: insert into pay_gb_year_end_values
1455: (ASSIGNMENT_ID,EFFECTIVE_END_DATE,NI_CATEGORY_CODE, REPORTABLE,

Line 1473: l_ni_tot := hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nif_tot_id) +

1469: end if; -- ] cat E for Females only
1470: -- populate NI F, NI G and/or NI S rows
1471: -- sum the NI F/G/S Total Balances
1472: l_ni_tot := 0;
1473: l_ni_tot := hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nif_tot_id) +
1474: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nig_tot_id) +
1475: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nis_tot_id);
1476: l_count := l_count + 3;
1477: -- if there is a total get the balance

Line 1474: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nig_tot_id) +

1470: -- populate NI F, NI G and/or NI S rows
1471: -- sum the NI F/G/S Total Balances
1472: l_ni_tot := 0;
1473: l_ni_tot := hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nif_tot_id) +
1474: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nig_tot_id) +
1475: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nis_tot_id);
1476: l_count := l_count + 3;
1477: -- if there is a total get the balance
1478: if l_ni_tot <> 0 then -- [ F/G/S Total(s) exist(s)

Line 1475: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nis_tot_id);

1471: -- sum the NI F/G/S Total Balances
1472: l_ni_tot := 0;
1473: l_ni_tot := hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nif_tot_id) +
1474: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nig_tot_id) +
1475: hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_nis_tot_id);
1476: l_count := l_count + 3;
1477: -- if there is a total get the balance
1478: if l_ni_tot <> 0 then -- [ F/G/S Total(s) exist(s)
1479: -- open cursor and populate year end values

Line 1576: l_nip := 100 * hr_dirbal.get_balance (l_people.LAST_ASG_ACTION_ID,l_nip_id);

1572: end if; -- ] F/G/S Total(s) Exist(s)
1573: --
1574: l_nip := 0;
1575: if l_nip_id <> 0 then
1576: l_nip := 100 * hr_dirbal.get_balance (l_people.LAST_ASG_ACTION_ID,l_nip_id);
1577: if l_nip <> 0 then
1578: insert into pay_gb_year_end_values
1579: (
1580: ASSIGNMENT_ID,

Line 1625: l_smp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_smp_id);

1621: between v.effective_start_date and v.effective_end_date;
1622: end if; -- ] no category balances
1623: -- populate the person balances
1624: if l_people.sex = 'F' then -- [ Maternity for females only
1625: l_smp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_smp_id);
1626: l_count := l_count + 1;
1627: else l_smp := 0;
1628: end if; -- ] Maternity for females only
1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);

Line 1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);

1625: l_smp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_smp_id);
1626: l_count := l_count + 1;
1627: else l_smp := 0;
1628: end if; -- ] Maternity for females only
1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);
1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);

Line 1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);

1626: l_count := l_count + 1;
1627: else l_smp := 0;
1628: end if; -- ] Maternity for females only
1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);
1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);
1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);

Line 1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);

1627: else l_smp := 0;
1628: end if; -- ] Maternity for females only
1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);
1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);
1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);
1635: l_count := l_count + 6;

Line 1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);

1628: end if; -- ] Maternity for females only
1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);
1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);
1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);
1635: l_count := l_count + 6;
1636: update pay_gb_year_end_assignments ye_asg set

Line 1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);

1629: l_ssp := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_ssp_id);
1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);
1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);
1635: l_count := l_count + 6;
1636: update pay_gb_year_end_assignments ye_asg set
1637: SSP = l_ssp,

Line 1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);

1630: l_gross := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_gross_id);
1631: l_paye := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_paye_id);
1632: l_super := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_super_id);
1633: l_widow := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_widow_id);
1634: l_taxable := 100 * hr_dirbal.get_balance(l_people.LAST_ASG_ACTION_ID,l_taxable_id);
1635: l_count := l_count + 6;
1636: update pay_gb_year_end_assignments ye_asg set
1637: SSP = l_ssp,
1638: SMP = l_smp,