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

Line 70: ,pay_balance_dimensions dim_old

66: CURSOR c_get_def_bal(p_balance_name VARCHAR2) IS
67: SELECT def_old.defined_balance_id old_id
68: ,def_new.defined_balance_id new_id
69: FROM pay_balance_types pbt
70: ,pay_balance_dimensions dim_old
71: ,pay_balance_dimensions dim_new
72: ,pay_defined_balances def_old
73: ,pay_defined_balances def_new
74: WHERE pbt.balance_name = p_balance_name

Line 71: ,pay_balance_dimensions dim_new

67: SELECT def_old.defined_balance_id old_id
68: ,def_new.defined_balance_id new_id
69: FROM pay_balance_types pbt
70: ,pay_balance_dimensions dim_old
71: ,pay_balance_dimensions dim_new
72: ,pay_defined_balances def_old
73: ,pay_defined_balances def_new
74: WHERE pbt.balance_name = p_balance_name
75: AND dim_old.database_item_suffix = '_PER_PAYE_REF_YTD'

Line 432: ,pay_balance_dimensions dim_old

428: CURSOR c_get_def_bal(p_balance_name VARCHAR2) IS
429: SELECT def_old.defined_balance_id old_id
430: ,def_new.defined_balance_id new_id
431: FROM pay_balance_types pbt
432: ,pay_balance_dimensions dim_old
433: ,pay_balance_dimensions dim_new
434: ,pay_defined_balances def_old
435: ,pay_defined_balances def_new
436: WHERE pbt.balance_name = p_balance_name

Line 433: ,pay_balance_dimensions dim_new

429: SELECT def_old.defined_balance_id old_id
430: ,def_new.defined_balance_id new_id
431: FROM pay_balance_types pbt
432: ,pay_balance_dimensions dim_old
433: ,pay_balance_dimensions dim_new
434: ,pay_defined_balances def_old
435: ,pay_defined_balances def_new
436: WHERE pbt.balance_name = p_balance_name
437: AND dim_old.database_item_suffix = '_PER_YTD'