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.HR_AUBAL dependencies on PAY_BALANCE_PKG

Line 14: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value

10: -- 21-Aug-2007 avenkatk 5371102 Cursor get_latest_id modified for performance, added join on payroll ID.
11: -- 23-Mar-2007 ksingla 5371102 Added hint USE_NL(ppa,paa) to cursor get_latest_id to remove MJC
12: -- 23-Jun-2004 srrajago 3603495 Cursor 'get_latest_id' modified for
13: -- Performance Fix.
14: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
15: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
16: -- Resolved GSCC errors.
17: -- 28-Aug-2003 Puchil 3010965 Changed the public functions to use
18: -- pay_balance_pkg.get_value

Line 15: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value

11: -- 23-Mar-2007 ksingla 5371102 Added hint USE_NL(ppa,paa) to cursor get_latest_id to remove MJC
12: -- 23-Jun-2004 srrajago 3603495 Cursor 'get_latest_id' modified for
13: -- Performance Fix.
14: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
15: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
16: -- Resolved GSCC errors.
17: -- 28-Aug-2003 Puchil 3010965 Changed the public functions to use
18: -- pay_balance_pkg.get_value
19: -- 28-Jul-2003 Vgsriniv 3057155 Replaced > than condition with >= for

Line 18: -- pay_balance_pkg.get_value

14: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
15: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value
16: -- Resolved GSCC errors.
17: -- 28-Aug-2003 Puchil 3010965 Changed the public functions to use
18: -- pay_balance_pkg.get_value
19: -- 28-Jul-2003 Vgsriniv 3057155 Replaced > than condition with >= for
20: -- checking expired year date in all the
21: -- relevant functions
22: -- 25-Jul-2003 Vgsriniv 3057155 Replaced > than condition with >= for

Line 244: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

240: -- calc_all_balances
241: -- this is the generic overloaded function for calculating all balances
242: -- in assignment action mode.
243: --
244: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
245: -----------------------------------------------------------------------------
246: --
247: function calc_all_balances ( p_assignment_action_id in number
248: , p_defined_balance_id in number

Line 256: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id

252: --
253: --
254: begin
255: --
256: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
257: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
258: ,P_TAX_UNIT_ID => null
259: ,P_JURISDICTION_CODE => null
260: ,P_SOURCE_ID => null

Line 274: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

270: -- calc_all_balances
271: -- this is the overloaded generic function for calculating all balances
272: -- in date mode.
273: --
274: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
275: -----------------------------------------------------------------------------
276: --
277: function calc_all_balances ( p_effective_date in date
278: , p_assignment_id in number

Line 290: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id

286: begin
287: --
288: l_assignment_action_id := get_latest_action_id( p_assignment_id, p_effective_date );
289: --
290: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
291: ,P_ASSIGNMENT_ACTION_ID => l_assignment_action_id
292: ,P_TAX_UNIT_ID => null
293: ,P_JURISDICTION_CODE => null
294: ,P_SOURCE_ID => null

Line 307: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

303: --
304: -- calc_asg_ytd
305: -- calculate balances for assignment year to date
306: --
307: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
308: --------------------------------------------------------------------------------
309: --
310: function calc_asg_ytd ( p_assignment_action_id in number
311: , p_balance_type_id in number

Line 327: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

323: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');
324: --
325: if l_defined_bal_id is not null then
326: --
327: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
328: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
329: ,P_TAX_UNIT_ID => null
330: ,P_JURISDICTION_CODE => null
331: ,P_SOURCE_ID => null

Line 445: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

441: --
442: -- calc_asg_mtd
443: -- calculate balances for assignment month to date
444: --
445: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
446: --------------------------------------------------------------------------------
447: --
448: -- will be set, otherwise session date is used.
449: --

Line 467: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

463: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_MTD');
464: --
465: if l_defined_bal_id is not null then
466: --
467: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
468: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
469: ,P_TAX_UNIT_ID => null
470: ,P_JURISDICTION_CODE => null
471: ,P_SOURCE_ID => null

Line 585: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

581: --
582: -- calc_asg_qtd
583: -- calculate balances for assignment month to date
584: --
585: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
586: --------------------------------------------------------------------------------
587: --
588: -- will be set, otherwise session date is used.
589: --

Line 607: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

603: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_QTD');
604: --
605: if l_defined_bal_id is not null then
606: --
607: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
608: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
609: ,P_TAX_UNIT_ID => null
610: ,P_JURISDICTION_CODE => null
611: ,P_SOURCE_ID => null

Line 723: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

719: --
720: -- calc_asg_cal_ytd
721: -- calculate balances for assignment year to date
722: --
723: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
724: --------------------------------------------------------------------------------
725: --
726: function calc_asg_cal_ytd( p_assignment_action_id in number
727: , p_balance_type_id in number

Line 743: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

739: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_CAL_YTD');
740: --
741: if l_defined_bal_id is not null then
742: --
743: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
744: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
745: ,P_TAX_UNIT_ID => null
746: ,P_JURISDICTION_CODE => null
747: ,P_SOURCE_ID => null

Line 857: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

853: --
854: -- calc_asg_fbt_ytd
855: -- calculate balances for FBT year to date
856: --
857: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
858: --------------------------------------------------------------------------------
859: --
860: function calc_asg_fbt_ytd( p_assignment_action_id in number
861: , p_balance_type_id in number

Line 876: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

872: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FBT_YTD');
873: --
874: if l_defined_bal_id is not null then
875: --
876: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
877: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
878: ,P_TAX_UNIT_ID => null
879: ,P_JURISDICTION_CODE => null
880: ,P_SOURCE_ID => null

Line 1010: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1006: --
1007: -- calc_asg_fy_ytd
1008: -- calculate balances for assignment fiscal year to date
1009: --
1010: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1011: --------------------------------------------------------------------------------
1012: --
1013: function calc_asg_fy_ytd( p_assignment_action_id in number
1014: , p_balance_type_id in number

Line 1030: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1026: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_YTD');
1027: --
1028: if l_defined_bal_id is not null then
1029: --
1030: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1031: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1032: ,P_TAX_UNIT_ID => null
1033: ,P_JURISDICTION_CODE => null
1034: ,P_SOURCE_ID => null

Line 1161: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1157: --
1158: -- calc_asg_fy_qtd
1159: -- calculate balances for assignment fiscal quarter to date
1160: --
1161: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1162: --------------------------------------------------------------------------------
1163: --
1164: function calc_asg_fy_qtd( p_assignment_action_id in number
1165: , p_balance_type_id in number

Line 1181: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1177: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_QTD');
1178: --
1179: if l_defined_bal_id is not null then
1180: --
1181: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1182: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1183: ,P_TAX_UNIT_ID => null
1184: ,P_JURISDICTION_CODE => null
1185: ,P_SOURCE_ID => null

Line 1304: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1300: --
1301: -- calc_asg_ptd
1302: -- calculate balances for assignment process period to date
1303: --
1304: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1305: -----------------------------------------------------------------------------
1306: --
1307: function calc_asg_ptd ( p_assignment_action_id in number
1308: , p_balance_type_id in number

Line 1325: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1321: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PTD');
1322: --
1323: if l_defined_bal_id is not null then
1324: --
1325: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1326: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1327: ,P_TAX_UNIT_ID => null
1328: ,P_JURISDICTION_CODE => null
1329: ,P_SOURCE_ID => null

Line 1449: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1445: -- calc_asg_td
1446: --
1447: -- calculate balances for assignment to date
1448: --
1449: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1450: -----------------------------------------------------------------------------
1451: --
1452: -- sum of all run items since inception.
1453: --

Line 1471: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1467: l_defined_bal_id := dimension_relevant(p_balance_type_id,'_ASG_TD');
1468: --
1469: if l_defined_bal_id is not null then
1470: --
1471: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1472: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1473: ,P_TAX_UNIT_ID => null
1474: ,P_JURISDICTION_CODE => null
1475: ,P_SOURCE_ID => null

Line 1575: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1571: --
1572: -- calc_asg_run
1573: -- calculate balances for assignment run
1574: --
1575: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1576: -----------------------------------------------------------------------------
1577: --
1578: function calc_asg_run ( p_assignment_action_id in number
1579: , p_balance_type_id in number

Line 1594: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1590: --
1591: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_RUN');
1592: if l_defined_bal_id is not null then
1593: --
1594: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1595: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1596: ,P_TAX_UNIT_ID => null
1597: ,P_JURISDICTION_CODE => null
1598: ,P_SOURCE_ID => null

Line 1709: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value

1705: --
1706: -- calc_payment
1707: -- calculate balances for payments
1708: --
1709: -- Bug 3010965 - Changed the function to use pay_balance_pkg.get_value
1710: -----------------------------------------------------------------------------
1711: --
1712: function calc_payment ( p_assignment_action_id in number
1713: , p_balance_type_id in number

Line 1729: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id

1725: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');
1726: --
1727: if l_defined_bal_id is not null then
1728: --
1729: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1730: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1731: ,P_TAX_UNIT_ID => null
1732: ,P_JURISDICTION_CODE => null
1733: ,P_SOURCE_ID => null