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.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_ALL_POSITIONS_F

Line 1826: FROM hr_all_positions_f pos, pqh_de_wrkplc_vldtn_vers wkvr

1822: AND effective_end_date >= p_assg_start_date;
1823:
1824: CURSOR c_tariff_contract(p_position_id per_all_assignments_f.position_id%type) IS
1825: SELECT wkvr.tariff_contract_code
1826: FROM hr_all_positions_f pos, pqh_de_wrkplc_vldtn_vers wkvr
1827: WHERE pos.position_id = p_position_id
1828: AND pos.information1='WP'
1829: AND to_char(wkvr.wrkplc_vldtn_ver_id) = decode(pos.information6,'A',pos.information5,pos.information9)
1830: AND p_assg_end_date between pos.effective_start_date and pos.effective_end_date