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_NZBAL dependencies on PAY_BALANCE_PKG

Line 16: -- pay_balance_pkg.get_value :

12: -- 18-Aug-2004 sshankar 115.13 3181581 Added function balance as it is being used by
13: -- view pay_nz_balances_v, view not created by any
14: -- script.
15: -- 10-Aug-2004 sshankar 115.12 3181581 Modified following functions to use
16: -- pay_balance_pkg.get_value :
17: -- CALC_ASG_4WEEK
18: -- CALC_ASG_FY_QTD
19: -- CALC_ASG_FY_YTD
20: -- CALC_ASG_HOL_YTD

Line 292: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

288: --
289: begin
290: --
291: -- Bug 3181581
292: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
293: --
294:
295: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
296: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id

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

291: -- Bug 3181581
292: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
293: --
294:
295: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
296: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
297: ,P_TAX_UNIT_ID => null
298: ,P_JURISDICTION_CODE => null
299: ,P_SOURCE_ID => null

Line 329: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

325: --
326: begin
327: --
328: -- Bug 3181581
329: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
330: --
331:
332: l_assignment_action_id := get_latest_action_id( p_assignment_id, p_effective_date );
333: --

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

330: --
331:
332: l_assignment_action_id := get_latest_action_id( p_assignment_id, p_effective_date );
333: --
334: return pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
335: ,P_ASSIGNMENT_ACTION_ID => l_assignment_action_id
336: ,P_TAX_UNIT_ID => null
337: ,P_JURISDICTION_CODE => null
338: ,P_SOURCE_ID => null

Line 380: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

376: --
377: begin
378: --
379: -- Bug 3181581
380: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
381: --
382:
383: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');
384: --

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

383: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');
384: --
385: if l_defined_bal_id is not null then
386: --
387: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
388: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
389: ,P_TAX_UNIT_ID => null
390: ,P_JURISDICTION_CODE => null
391: ,P_SOURCE_ID => null

Line 533: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

529: --
530: begin
531: --
532: -- Bug 3181581
533: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
534: --
535:
536: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_HOL_YTD');
537: --

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

536: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_HOL_YTD');
537: --
538: if l_defined_bal_id is not null then
539: --
540: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
541: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
542: ,P_TAX_UNIT_ID => null
543: ,P_JURISDICTION_CODE => null
544: ,P_SOURCE_ID => null

Line 1018: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1014: --
1015: begin
1016: --
1017: -- Bug 3181581
1018: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1019: --
1020: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_YTD');
1021:
1022: --

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

1021:
1022: --
1023: if l_defined_bal_id is not null then
1024: --
1025: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1026: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1027: ,P_TAX_UNIT_ID => null
1028: ,P_JURISDICTION_CODE => null
1029: ,P_SOURCE_ID => null

Line 1177: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1173: --
1174: begin
1175: --
1176: -- Bug 3181581
1177: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1178: --
1179: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_QTD');
1180: --
1181: if l_defined_bal_id is not null then

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

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

Line 1310: -- Bug 3181581, modified to fetch balance by calling pay_balance_pkg.get_value

1306: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1307: --
1308: begin
1309: --
1310: -- Bug 3181581, modified to fetch balance by calling pay_balance_pkg.get_value
1311: --
1312: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_4WEEK');
1313: --
1314: if l_defined_bal_id is not null then

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

1312: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_4WEEK');
1313: --
1314: if l_defined_bal_id is not null then
1315: --
1316: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1317: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1318: ,P_TAX_UNIT_ID => null
1319: ,P_JURISDICTION_CODE => null
1320: ,P_SOURCE_ID => null

Line 1466: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1462: --
1463: begin
1464: --
1465: -- Bug 3181581
1466: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1467: --
1468:
1469: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PTD');
1470: --

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

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

Line 1600: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1596: --
1597: begin
1598: --
1599: -- Bug 3181581
1600: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1601: --
1602:
1603: l_defined_bal_id := dimension_relevant(p_balance_type_id,'_ASG_TD');
1604: --

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

1603: l_defined_bal_id := dimension_relevant(p_balance_type_id,'_ASG_TD');
1604: --
1605: if l_defined_bal_id is not null then
1606: --
1607: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1608: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1609: ,P_TAX_UNIT_ID => null
1610: ,P_JURISDICTION_CODE => null
1611: ,P_SOURCE_ID => null

Line 1750: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1746: --
1747: begin
1748: --
1749: -- Bug 3181581
1750: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1751: --
1752:
1753: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_RUN');
1754:

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

1753: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_RUN');
1754:
1755: if l_defined_bal_id is not null then
1756: --
1757: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1758: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1759: ,P_TAX_UNIT_ID => null
1760: ,P_JURISDICTION_CODE => null
1761: ,P_SOURCE_ID => null

Line 1897: -- Modified code to fetch balance by calling pay_balance_pkg.get_value

1893: --
1894: begin
1895: --
1896: -- Bug 3181581
1897: -- Modified code to fetch balance by calling pay_balance_pkg.get_value
1898: --
1899:
1900: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');
1901: --

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

1900: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');
1901: --
1902: if l_defined_bal_id is not null then
1903: --
1904: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => l_defined_bal_id
1905: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1906: ,P_TAX_UNIT_ID => null
1907: ,P_JURISDICTION_CODE => null
1908: ,P_SOURCE_ID => null

Line 1942: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id

1938: --
1939: l_balance number;
1940: begin
1941: --
1942: l_balance := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID => p_defined_balance_id
1943: ,P_ASSIGNMENT_ACTION_ID => p_assignment_action_id
1944: ,P_TAX_UNIT_ID => null
1945: ,P_JURISDICTION_CODE => null
1946: ,P_SOURCE_ID => null