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_SG_SOE dependencies on PAY_BALANCE_DIMENSIONS

Line 145: c_dimension_name pay_balance_dimensions.dimension_name%type) is

141: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
142: cursor balance_value
143: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
144: c_balance_name pay_balance_types.balance_name%type,
145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,
148: pay_defined_balances pdb,
149: pay_balance_types pbt

Line 147: from pay_balance_dimensions pbd,

143: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
144: c_balance_name pay_balance_types.balance_name%type,
145: c_dimension_name pay_balance_dimensions.dimension_name%type) is
146: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
147: from pay_balance_dimensions pbd,
148: pay_defined_balances pdb,
149: pay_balance_types pbt
150: where pbt.balance_name = c_balance_name
151: and pbd.dimension_name = c_dimension_name

Line 379: c_dimension_name pay_balance_dimensions.dimension_name%type) is

375: /* Bug:2883606. Cursor to get the balance values from pay_balance_pkg.get_value */
376: cursor balance_value
377: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
378: c_balance_name pay_balance_types.balance_name%type,
379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,
382: pay_defined_balances pdb,
383: pay_balance_types pbt

Line 381: from pay_balance_dimensions pbd,

377: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
378: c_balance_name pay_balance_types.balance_name%type,
379: c_dimension_name pay_balance_dimensions.dimension_name%type) is
380: select nvl(pay_balance_pkg.get_value(pdb.defined_balance_id,c_assignment_action_id),0)
381: from pay_balance_dimensions pbd,
382: pay_defined_balances pdb,
383: pay_balance_types pbt
384: where pbt.balance_name = c_balance_name
385: and pbd.dimension_name = c_dimension_name