APPS.HR_NZBAL dependencies on PAY_DEFINED_BALANCES

Line 174: from pay_defined_balances pdb

170: cursor relevant ( c_balance_type_id in number
171: , c_db_item_suffix in varchar2
172: ) is
173: select pdb.defined_balance_id
174: from pay_defined_balances pdb
175: , pay_balance_dimensions pbd
176: where pdb.balance_dimension_id = pbd.balance_dimension_id
177: and pbd.database_item_suffix = c_db_item_suffix
178: and pdb.balance_type_id = c_balance_type_id;

Line 375: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

371: return number
372: is
373: --
374: l_balance number;
375: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
376: --
377: begin
378: --
379: -- Bug 3181581

Line 528: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

524: return number
525: is
526: --
527: l_balance number;
528: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
529: --
530: begin
531: --
532: -- Bug 3181581

Line 1013: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1009: return number
1010: is
1011: --
1012: l_balance number;
1013: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1014: --
1015: begin
1016: --
1017: -- Bug 3181581

Line 1172: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1168: return number
1169: is
1170: --
1171: l_balance number;
1172: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1173: --
1174: begin
1175: --
1176: -- Bug 3181581

Line 1306: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1302: return number
1303: is
1304: --
1305: l_balance number;
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

Line 1461: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1457: return number
1458: is
1459: --
1460: l_balance number;
1461: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1462: --
1463: begin
1464: --
1465: -- Bug 3181581

Line 1595: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1591: return number
1592: is
1593: --
1594: l_balance number;
1595: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1596: --
1597: begin
1598: --
1599: -- Bug 3181581

Line 1745: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1741: return number
1742: is
1743: --
1744: l_balance number;
1745: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1746: --
1747: begin
1748: --
1749: -- Bug 3181581

Line 1892: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1888: return number
1889: is
1890: --
1891: l_balance number;
1892: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1893: --
1894: begin
1895: --
1896: -- Bug 3181581