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

Line 68: ,pay_balance_dimensions pbd

64: IS
65: SELECT pdb.defined_balance_id
66: FROM pay_defined_balances pdb
67: ,pay_balance_types pbt
68: ,pay_balance_dimensions pbd
69: WHERE pdb.balance_type_id = pbt.balance_type_id
70: AND pdb.balance_dimension_id = pbd.balance_dimension_id
71: AND pbt.legislation_code = 'AU'
72: AND pbd.legislation_code = 'AU'

Line 674: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE

670: */
671:
672:
673: PROCEDURE get_defined_balances(p_balances_tab IN pay_au_foreign_workers.tab_bal_type
674: ,p_dimension_name IN pay_balance_dimensions.dimension_name%TYPE
675: ,p_def_bal_tab OUT NOCOPY pay_balance_pkg.t_balance_value_tab
676: )
677: IS
678:

Line 681: ,c_dim_name pay_balance_dimensions.dimension_name%TYPE)

677: IS
678:
679: CURSOR csr_get_def_bal
680: (c_balance_type_id pay_balance_types.balance_type_id%TYPE
681: ,c_dim_name pay_balance_dimensions.dimension_name%TYPE)
682: IS
683: SELECT pdb.defined_balance_id
684: FROM pay_defined_balances pdb
685: ,pay_balance_dimensions pbd

Line 685: ,pay_balance_dimensions pbd

681: ,c_dim_name pay_balance_dimensions.dimension_name%TYPE)
682: IS
683: SELECT pdb.defined_balance_id
684: FROM pay_defined_balances pdb
685: ,pay_balance_dimensions pbd
686: ,pay_balance_types pbt
687: WHERE pbt.balance_type_id = c_balance_type_id
688: AND pdb.balance_type_id = pbt.balance_type_id
689: AND pdb.balance_dimension_id = pbd.balance_dimension_id