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_GBBAL dependencies on PAY_DEFINED_BALANCES

Line 317: pay_defined_balances pdb,

313: --
314: cursor relevant(c_balance_type_id IN NUMBER,
315: c_db_item_suffix IN VARCHAR2) IS
316: select pdb.defined_balance_id from
317: pay_defined_balances pdb,
318: pay_balance_dimensions pbd
319: where pdb.balance_dimension_id = pbd.balance_dimension_id
320: and pbd.database_item_suffix = c_db_item_suffix
321: and pdb.balance_type_id = c_balance_type_id;

Line 685: pay_defined_balances DB,

681: DIM.database_item_suffix ,
682: DIM.legislation_code,
683: DIM.business_group_id
684: FROM
685: pay_defined_balances DB,
686: pay_balance_dimensions DIM
687: WHERE DB.defined_balance_id = p_defined_balance_id
688: AND DIM.balance_dimension_id = DB.balance_dimension_id;
689: --

Line 1020: pay_defined_balances pdb

1016: cursor get_balance_type_id(c_defined_balance_id IN NUMBER) IS
1017: select pdb.balance_type_id,
1018: pbd.dimension_name
1019: from pay_balance_dimensions pbd,
1020: pay_defined_balances pdb
1021: where pdb.defined_balance_id = c_defined_balance_id
1022: and pdb.balance_dimension_id = pbd.balance_dimension_id;
1023: --
1024: BEGIN

Line 1123: pay_defined_balances pdb

1119: select pdb.balance_type_id,
1120: pbd.dimension_name,
1121: pbd.route_id
1122: from pay_balance_dimensions pbd,
1123: pay_defined_balances pdb
1124: where pdb.defined_balance_id = c_defined_balance_id
1125: and pdb.balance_dimension_id = pbd.balance_dimension_id;
1126: --
1127: cursor get_context(p_route_id IN NUMBER,

Line 3554: l_niable_def_id pay_defined_balances.defined_balance_id%type;

3550: p_category in varchar2)
3551: RETURN number is
3552: l_return number;
3553: l_regular_payment_date per_time_periods.regular_payment_date%type;
3554: l_niable_def_id pay_defined_balances.defined_balance_id%type;
3555: l_nitotal_def_id pay_defined_balances.defined_balance_id%type;
3556: l_nitotal_value number;
3557: l_niable_value number;
3558: --

Line 3555: l_nitotal_def_id pay_defined_balances.defined_balance_id%type;

3551: RETURN number is
3552: l_return number;
3553: l_regular_payment_date per_time_periods.regular_payment_date%type;
3554: l_niable_def_id pay_defined_balances.defined_balance_id%type;
3555: l_nitotal_def_id pay_defined_balances.defined_balance_id%type;
3556: l_nitotal_value number;
3557: l_niable_value number;
3558: --
3559:

Line 3923: from pay_defined_balances

3919: g_ni_l_defbal_id,
3920: g_ni_l_able_defbal_id,
3921: g_ni_s_defbal_id,
3922: g_ni_s_able_defbal_id
3923: from pay_defined_balances
3924: where balance_dimension_id = g_asg_td_ytd
3925: and balance_type_id in
3926: (g_ni_a_id, g_ni_a_able_id
3927: ,g_ni_b_id, g_ni_b_able_id