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

Line 739: FROM pay_defined_balances db

735: (p_business_group_id IN NUMBER
736: ,p_balance_name IN VARCHAR2
737: ,p_database_item_suffix IN VARCHAR) IS
738: SELECT db.defined_balance_id
739: FROM pay_defined_balances db
740: ,pay_balance_dimensions bd
741: ,pay_balance_types bt
742: WHERE bt.balance_name = p_balance_name
743: AND ((bt.business_group_id IS NULL AND bt.legislation_code = 'NO') OR (bt.legislation_code IS NULL AND bt.business_group_id = p_business_group_id))

Line 2028: FROM pay_defined_balances pdb

2024: CURSOR csr_seaman_bal_status
2025: (l_classification_id IN NUMBER
2026: ,l_defined_balance_id IN NUMBER) IS
2027: SELECT 'Y'
2028: FROM pay_defined_balances pdb
2029: ,pay_balance_classifications pbc
2030: WHERE pbc.classification_id = l_classification_id
2031: AND pdb.balance_type_id = pbc.balance_type_id
2032: AND pdb.defined_balance_id = l_defined_balance_id;