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 13: -- 07-May-2004 avenkatk 3580487 Changed calls to pay_balance_pkg.get_value

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

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

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

Line 17: -- pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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