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_AC_ACTION_ARCH dependencies on PAY_BALANCE_TYPES

Line 417: ,PBT PAY_BALANCE_TYPES_PK,

413: ,cp_start_eff_date in date
414: ) is
415: select /*+ ORDERED INDEX(PRB PAY_RUN_BALANCES_N1
416: ,PDB PAY_DEFINED_BALANCES_PK
417: ,PBT PAY_BALANCE_TYPES_PK,
418: ,PET PAY_ELEMENT_TYPES_F_PK
419: ,PEC PAY_ELEMENT_CLASSIFICATION_PK
420: ,PETL PAY_ELEMENT_TYPES_F_TL_PK)
421: USE_NL(PRB, PDB, PBT, PET, PEC, PETL) */

Line 445: ,pay_balance_types pbt

441: pet.element_information10,
442: pet.element_information12
443: from pay_run_balances prb
444: ,pay_defined_balances pdb
445: ,pay_balance_types pbt
446: ,pay_element_types_f pet
447: ,pay_element_classifications pec
448: ,pay_element_types_f_tl petl
449: where prb.effective_date >= cp_start_eff_date

Line 2573: from pay_balance_types

2569:
2570: cursor c_get_balance (cp_balance_name in varchar2
2571: ,cp_legislation_code in varchar2) is
2572: select balance_type_id
2573: from pay_balance_types
2574: where legislation_code = cp_legislation_code
2575: and balance_name = cp_balance_name;
2576:
2577: ln_element_type_id NUMBER;