APPS.HR_AUBAL dependencies on PAY_DEFINED_BALANCES

Line 90: from pay_defined_balances pdb

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

Line 316: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 456: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 596: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 732: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 865: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1019: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1170: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1314: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1460: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1584: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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

Line 1718: l_defined_bal_id pay_defined_balances.defined_balance_id%TYPE;

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