APPS.HR_AUBAL dependencies on PAY_DEFINED_BALANCES

Line 91: from pay_defined_balances pdb

87: cursor relevant ( c_balance_type_id in number
88: , c_db_item_suffix in varchar2
89: ) is
90: select pdb.defined_balance_id
91: from pay_defined_balances pdb
92: , pay_balance_dimensions pbd
93: where pdb.balance_dimension_id = pbd.balance_dimension_id
94: and pbd.database_item_suffix = c_db_item_suffix
95: and pdb.balance_type_id = c_balance_type_id;

Line 319: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

315: return number
316: is
317: --
318: l_balance number;
319: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
320: --
321: begin
322: --
323: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_YTD');

Line 459: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

455: return number
456: is
457: --
458: l_balance number;
459: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
460: --
461: begin
462: --
463: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_MTD');

Line 599: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

595: return number
596: is
597: --
598: l_balance number;
599: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
600: --
601: begin
602: --
603: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_QTD');

Line 735: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

731: return number
732: is
733: --
734: l_balance number;
735: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
736: --
737: begin
738: --
739: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_CAL_YTD');

Line 868: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

864: return number
865: is
866: --
867: l_balance number;
868: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
869: --
870: begin
871: --
872: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FBT_YTD');

Line 1022: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1018: return number
1019: is
1020: --
1021: l_balance number;
1022: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1023: --
1024: begin
1025: --
1026: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_YTD');

Line 1173: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1169: return number
1170: is
1171: --
1172: l_balance number;
1173: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1174: --
1175: begin
1176: --
1177: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_FY_QTD');

Line 1317: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1313: return number
1314: is
1315: --
1316: l_balance number;
1317: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1318: --
1319: begin
1320: --
1321: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_PTD');

Line 1463: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1459: return number
1460: is
1461: --
1462: l_balance number;
1463: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1464: --
1465: begin
1466: --
1467: l_defined_bal_id := dimension_relevant(p_balance_type_id,'_ASG_TD');

Line 1587: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1583: return number
1584: is
1585: --
1586: l_balance number;
1587: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1588: --
1589: begin
1590: --
1591: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_ASG_RUN');

Line 1721: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

1717: return number
1718: is
1719: --
1720: l_balance number;
1721: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;
1722: --
1723: begin
1724: --
1725: l_defined_bal_id := dimension_relevant(p_balance_type_id, '_PAYMENTS');