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

Line 51: p_dimension_name in pay_balance_dimensions.dimension_name%type)

47: -- Sums the Balances for This Pay and YTD, according to the parameters.
48: ------------------------------------------------------------------------
49: function get_balance_id
50: (p_balance_name in pay_balance_types.balance_name%type,
51: p_dimension_name in pay_balance_dimensions.dimension_name%type)
52: return pay_defined_balances.defined_balance_id%type
53: is
54:
55: p_defined_balance_id pay_defined_balances.defined_balance_id%type;

Line 59: c_dimension_name pay_balance_dimensions.dimension_name%type) is

55: p_defined_balance_id pay_defined_balances.defined_balance_id%type;
56:
57: cursor balance_id
58: (c_balance_name pay_balance_types.balance_name%type,
59: c_dimension_name pay_balance_dimensions.dimension_name%type) is
60: select
61: pdb.defined_balance_id
62: from pay_balance_types pbt,
63: pay_defined_balances pdb,

Line 64: pay_balance_dimensions pbd

60: select
61: pdb.defined_balance_id
62: from pay_balance_types pbt,
63: pay_defined_balances pdb,
64: pay_balance_dimensions pbd
65: where pbt.balance_type_id = pdb.balance_type_id
66: and pdb.balance_dimension_id = pbd.balance_dimension_id
67: and pbd.dimension_name = c_dimension_name
68: and pbt.balance_name = c_balance_name

Line 107: (c_dimension_name pay_balance_dimensions.dimension_name%type)

103: ------------------------------------------------------------------------
104: -- cursor to get the defined balance ids for the various balances --3609072
105: ------------------------------------------------------------------------
106: CURSOR c_get_defined_balance_id
107: (c_dimension_name pay_balance_dimensions.dimension_name%type)
108: IS
109: SELECT decode(pbt.balance_name, 'GROSS_PAY',1
110: , 'MANDATORY_DEDUCTIONS',2
111: , 'INVOLUNTARY_DEDUCTIONS',3

Line 118: pay_balance_dimensions pbd,

114: , 'DIRECT_PAYMENTS',6
115: , 'TOTAL_PAYMENTS',7) sort_index,
116: pdb.defined_balance_id defined_balance_id
117: FROM pay_balance_types pbt,
118: pay_balance_dimensions pbd,
119: pay_defined_balances pdb
120: WHERE pbt.balance_name IN ('GROSS_PAY'
121: , 'MANDATORY_DEDUCTIONS'
122: , 'INVOLUNTARY_DEDUCTIONS'

Line 420: l_dimension pay_balance_dimensions.dimension_name%type;

416:
417: l_date_earned DATE;
418: l_tax_unit_id NUMBER;
419: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
420: l_dimension pay_balance_dimensions.dimension_name%type;
421:
422: CURSOR csr_locked_action_id
423: IS
424: SELECT max(locked_action_id)

Line 479: , pay_balance_dimensions pbd_ptd

475: , NULL
476: , NULL)
477: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
478: FROM pay_balance_types pbt
479: , pay_balance_dimensions pbd_ptd
480: , pay_balance_dimensions pbd_ytd
481: , pay_defined_balances pdb_ptd
482: , pay_defined_balances pdb_ytd
483: WHERE pbt.balance_name IN (''GROSS_PAY''

Line 480: , pay_balance_dimensions pbd_ytd

476: , NULL)
477: , fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
478: FROM pay_balance_types pbt
479: , pay_balance_dimensions pbd_ptd
480: , pay_balance_dimensions pbd_ytd
481: , pay_defined_balances pdb_ptd
482: , pay_defined_balances pdb_ytd
483: WHERE pbt.balance_name IN (''GROSS_PAY''
484: , ''MANDATORY_DEDUCTIONS''