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.

[Home] [Help]

APPS.PAY_AC_ACTION_ARCH dependencies on PAY_RUN_BALANCES

Line 415: select /*+ ORDERED INDEX(PRB PAY_RUN_BALANCES_N1

411: cursor c_prev_ytd_action_elem_rbr(cp_assignment_id in number
412: ,cp_curr_eff_date in date
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

Line 443: from pay_run_balances prb

439: rpad(nvl(substr(rtrim(ltrim(jurisdiction_code)),8,4),'0')
440: ,4,'0')))), '00-000-0000') jurisdiction_code,
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