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

Line 1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1123: AND pbd.balance_dimension_id = pdb.balance_dimension_id
1124: ORDER BY pbt.balance_name;
1125:
1126: g_bal_name_tab t_bal_name_tab;
1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1128: g_context_table pay_balance_pkg.t_context_tab;
1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1128: g_context_table pay_balance_pkg.t_context_tab;

1124: ORDER BY pbt.balance_name;
1125:
1126: g_bal_name_tab t_bal_name_tab;
1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1128: g_context_table pay_balance_pkg.t_context_tab;
1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1132:

Line 1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1125:
1126: g_bal_name_tab t_bal_name_tab;
1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1128: g_context_table pay_balance_pkg.t_context_tab;
1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1132:
1133: i NUMBER;

Line 1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1126: g_bal_name_tab t_bal_name_tab;
1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1128: g_context_table pay_balance_pkg.t_context_tab;
1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1132:
1133: i NUMBER;
1134: l_action_info_id NUMBER;

Line 1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1127: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1128: g_context_table pay_balance_pkg.t_context_tab;
1129: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1130: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1131: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1132:
1133: i NUMBER;
1134: l_action_info_id NUMBER;
1135: l_ovn NUMBER;

Line 1187: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1183:
1184: g_balance_value_tab1(1).defined_balance_id :=
1185: pay_in_tax_utils.get_defined_balance('Gross Chapter VIA Deductions','_ASG_LE_COMP_PTD');
1186:
1187: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1188: ,p_defined_balance_lst => g_balance_value_tab1
1189: ,p_context_lst => g_context_table
1190: ,p_output_table => g_result_table1
1191: );

Line 1212: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1208: g_context_table(4).source_text2 := 'Senior Citizens Savings Scheme';
1209: g_context_table(4).tax_unit_id := p_gre_id;
1210:
1211:
1212: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1213: ,p_defined_balance_lst => g_balance_value_tab1
1214: ,p_context_lst => g_context_table
1215: ,p_output_table => g_result_table1
1216: );

Line 1236: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1232: g_bal_name_tab(i).balance_name := c_rec.balance_name;
1233: i := i + 1;
1234: END LOOP;
1235:
1236: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1237: ,p_defined_balance_lst => g_balance_value_tab
1238: ,p_context_lst => g_context_table
1239: ,p_output_table => g_result_table
1240: );

Line 1460: g_context_table pay_balance_pkg.t_context_tab;

1456: AND pbt.balance_type_id = pdb.balance_type_id
1457: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1458:
1459: g_bal_name_tab t_bal_name_tab;
1460: g_context_table pay_balance_pkg.t_context_tab;
1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

Line 1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1457: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1458:
1459: g_bal_name_tab t_bal_name_tab;
1460: g_context_table pay_balance_pkg.t_context_tab;
1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1465:

Line 1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1458:
1459: g_bal_name_tab t_bal_name_tab;
1460: g_context_table pay_balance_pkg.t_context_tab;
1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1465:
1466: l_allow_proj_value NUMBER;

Line 1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1459: g_bal_name_tab t_bal_name_tab;
1460: g_context_table pay_balance_pkg.t_context_tab;
1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1465:
1466: l_allow_proj_value NUMBER;
1467: l_balance_value NUMBER;

Line 1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

1460: g_context_table pay_balance_pkg.t_context_tab;
1461: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1462: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1463: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1464: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1465:
1466: l_allow_proj_value NUMBER;
1467: l_balance_value NUMBER;
1468: l_action_info_id NUMBER;

Line 1512: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1508: g_bal_name_tab(i).balance_name := c_rec.balance_name;
1509: i := i + 1;
1510: END LOOP;
1511:
1512: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1513: ,p_defined_balance_lst => g_balance_value_tab
1514: ,p_context_lst => g_context_table
1515: ,p_output_table => g_result_table
1516: );

Line 1579: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);

1575: g_bal_name_tab(i).balance_name := c_rec.balance_name;
1576: i := i + 1;
1577: END LOOP;
1578:
1579: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);
1580:
1581: IF pre_gre_asg_act_id IS NOT NULL THEN
1582: pay_balance_pkg.get_value(pre_gre_asg_act_id,g_balance_value_tab2);
1583: END IF;

Line 1582: pay_balance_pkg.get_value(pre_gre_asg_act_id,g_balance_value_tab2);

1578:
1579: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);
1580:
1581: IF pre_gre_asg_act_id IS NOT NULL THEN
1582: pay_balance_pkg.get_value(pre_gre_asg_act_id,g_balance_value_tab2);
1583: END IF;
1584:
1585: --Step 3:Archive values
1586: FOR i IN 1..g_balance_value_tab1.COUNT

Line 1642: -- IN : g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab --

1638: -- Access : Private --
1639: -- Description : This procedure is used to find the difference in --
1640: -- values of 2 PL/SQL tables --
1641: -- Parameters : --
1642: -- IN : g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab --
1643: -- g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab --
1644: -- IN/OUT : g_result_table --
1645: -- --
1646: -- Change History : --

Line 1643: -- g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab --

1639: -- Description : This procedure is used to find the difference in --
1640: -- values of 2 PL/SQL tables --
1641: -- Parameters : --
1642: -- IN : g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab --
1643: -- g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab --
1644: -- IN/OUT : g_result_table --
1645: -- --
1646: -- Change History : --
1647: --------------------------------------------------------------------------

Line 1652: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab

1648: -- Rev# Date Userid Description --
1649: --------------------------------------------------------------------------
1650: -- 115.0 05-Jan-2006 lnagaraj Initial Version --
1651: --------------------------------------------------------------------------
1652: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
1653: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
1654: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1655: )
1656: IS

Line 1653: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab

1649: --------------------------------------------------------------------------
1650: -- 115.0 05-Jan-2006 lnagaraj Initial Version --
1651: --------------------------------------------------------------------------
1652: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
1653: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
1654: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1655: )
1656: IS
1657: l_proc VARCHAR2(100);

Line 1654: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

1650: -- 115.0 05-Jan-2006 lnagaraj Initial Version --
1651: --------------------------------------------------------------------------
1652: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
1653: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
1654: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1655: )
1656: IS
1657: l_proc VARCHAR2(100);
1658: l_message VARCHAR2(255);

Line 1689: -- IN/OUT :g_context_table pay_balance_pkg.t_context_tab --

1685: -- IN : p_run_asg_action_id NUMBER --
1686: -- pre_gre_asg_act_id NUMBER --
1687: -- p_balance_name VARCHAR2 --
1688: -- p_balance_dimension VARCHAR2 --
1689: -- IN/OUT :g_context_table pay_balance_pkg.t_context_tab --
1690: -- g_balance_value_tab pay_balance_pkg.t_balance_value_tab--
1691: -- g_result_table pay_balance_pkg.t_detailed_bal_out_tab --
1692: -- --
1693: -- Change History : --

Line 1690: -- g_balance_value_tab pay_balance_pkg.t_balance_value_tab--

1686: -- pre_gre_asg_act_id NUMBER --
1687: -- p_balance_name VARCHAR2 --
1688: -- p_balance_dimension VARCHAR2 --
1689: -- IN/OUT :g_context_table pay_balance_pkg.t_context_tab --
1690: -- g_balance_value_tab pay_balance_pkg.t_balance_value_tab--
1691: -- g_result_table pay_balance_pkg.t_detailed_bal_out_tab --
1692: -- --
1693: -- Change History : --
1694: --------------------------------------------------------------------------

Line 1691: -- g_result_table pay_balance_pkg.t_detailed_bal_out_tab --

1687: -- p_balance_name VARCHAR2 --
1688: -- p_balance_dimension VARCHAR2 --
1689: -- IN/OUT :g_context_table pay_balance_pkg.t_context_tab --
1690: -- g_balance_value_tab pay_balance_pkg.t_balance_value_tab--
1691: -- g_result_table pay_balance_pkg.t_detailed_bal_out_tab --
1692: -- --
1693: -- Change History : --
1694: --------------------------------------------------------------------------
1695: -- Rev# Date Userid Description --

Line 1703: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab

1699: PROCEDURE get_balances(p_run_asg_action_id IN NUMBER
1700: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1701: ,p_balance_name IN VARCHAR2 DEFAULT NULL
1702: ,p_balance_dimension IN VARCHAR2 DEFAULT NULL
1703: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
1704: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
1705: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1706: )
1707: IS

Line 1704: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab

1700: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1701: ,p_balance_name IN VARCHAR2 DEFAULT NULL
1702: ,p_balance_dimension IN VARCHAR2 DEFAULT NULL
1703: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
1704: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
1705: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1706: )
1707: IS
1708:

Line 1705: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

1701: ,p_balance_name IN VARCHAR2 DEFAULT NULL
1702: ,p_balance_dimension IN VARCHAR2 DEFAULT NULL
1703: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
1704: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
1705: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1706: )
1707: IS
1708:
1709: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1709: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1705: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
1706: )
1707: IS
1708:
1709: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1710: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1711: l_proc VARCHAR2(100);
1712: l_message VARCHAR2(255);
1713:

Line 1710: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1706: )
1707: IS
1708:
1709: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1710: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1711: l_proc VARCHAR2(100);
1712: l_message VARCHAR2(255);
1713:
1714: BEGIN

Line 1734: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1730: g_balance_value_tab(1).defined_balance_id :=
1731: pay_in_tax_utils.get_defined_balance(p_balance_name,p_balance_dimension);
1732: END IF;
1733:
1734: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1735: ,p_defined_balance_lst => g_balance_value_tab
1736: ,p_context_lst => g_context_table
1737: ,p_output_table => l_result_table1
1738: );

Line 1742: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

1738: );
1739:
1740: IF pre_gre_asg_act_id IS NOT NULL
1741: THEN
1742: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
1743: ,p_defined_balance_lst => g_balance_value_tab
1744: ,p_context_lst => g_context_table
1745: ,p_output_table => l_result_table2
1746: );

Line 1825: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1821: AND pbd.legislation_code = 'IN'
1822: AND pbt.balance_type_id = pdb.balance_type_id
1823: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1824:
1825: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;

Line 1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1822: AND pbt.balance_type_id = pdb.balance_type_id
1823: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1824:
1825: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

1823: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1824:
1825: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1829: g_context_table pay_balance_pkg.t_context_tab;

1825: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1832: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1833:

Line 1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1826: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1832: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1833:
1834: l_balance_value NUMBER;

Line 1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1827: g_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1832: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1833:
1834: l_balance_value NUMBER;
1835: l_defined_balance_id NUMBER;

Line 1832: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1828: g_bal_name_tab t_bal_name_tab;
1829: g_context_table pay_balance_pkg.t_context_tab;
1830: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1831: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1832: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1833:
1834: l_balance_value NUMBER;
1835: l_defined_balance_id NUMBER;
1836: l_total_value NUMBER;

Line 1871: l_total_value := pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,

1867: end if;
1868:
1869: l_defined_balance_id :=pay_in_tax_utils.get_defined_balance('Cost and Rent of Furniture','_ASG_YTD');
1870:
1871: l_total_value := pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1872: p_defined_balance_id => l_defined_balance_id);
1873:
1874: if g_debug then
1875: pay_in_utils.trace('l_total_value : ',l_total_value);

Line 1879: l_prev_gre_value := pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,

1875: pay_in_utils.trace('l_total_value : ',l_total_value);
1876: end if;
1877:
1878: IF pre_gre_asg_act_id IS NOT NULL THEN
1879: l_prev_gre_value := pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,
1880: p_defined_balance_id => l_defined_balance_id);
1881: if g_debug then
1882: pay_in_utils.trace('l_prev_gre_value : ',l_prev_gre_value);
1883: end if;

Line 1926: l_balance_value := pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,

1922: ,g_balance_value_tab => g_balance_value_tab1
1923: ,g_result_table => g_result_table1
1924: );
1925: l_defined_balance_id :=pay_in_tax_utils.get_defined_balance('Projected Employee Contribution for Company Accommodation','_ASG_PTD');
1926: l_balance_value := pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1927: p_defined_balance_id => l_defined_balance_id);
1928:
1929:
1930: if g_debug then

Line 1965: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,

1961: g_balance_value_tab2(i).defined_balance_id := c_rec.balance_id;
1962: g_bal_name_tab(i).balance_name := c_rec.balance_name;
1963: END LOOP;
1964:
1965: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1966: p_defined_balance_lst => g_balance_value_tab1);
1967:
1968: IF pre_gre_asg_act_id IS NOT NULL THEN
1969: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,

Line 1969: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,

1965: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1966: p_defined_balance_lst => g_balance_value_tab1);
1967:
1968: IF pre_gre_asg_act_id IS NOT NULL THEN
1969: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,
1970: p_defined_balance_lst => g_balance_value_tab2);
1971: FOR i in 1..3
1972: LOOP
1973: g_balance_value_tab1(i).balance_value := g_balance_value_tab1(i).balance_value - g_balance_value_tab2(i).balance_value;

Line 1985: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,

1981: i :=c_rec.indx;
1982: g_balance_value_tab(i).defined_balance_id := c_rec.balance_id;
1983: END LOOP;
1984:
1985: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1986: p_defined_balance_lst => g_balance_value_tab);
1987:
1988:
1989: if g_debug then