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_US_GET_ITEM_DATA_PKG dependencies on HR_ALL_POSITIONS_F

Line 191: hr_all_positions_f hpf

187: c_date_earned date)
188: IS
189: SELECT hpf.name
190: FROM per_all_assignments_f paf,
191: hr_all_positions_f hpf
192: WHERE paf.position_id = hpf.position_id
193: AND paf.person_id = c_person_id
194: AND c_date_earned BETWEEN paf.effective_start_date
195: AND paf.effective_end_date;

Line 220: l_position hr_all_positions_f.name%TYPE := '';

216: l_phone_type per_phones.phone_type%TYPE := '';
217: l_fax per_phones.phone_number%TYPE := '';
218: l_email per_all_people_f.email_address%TYPE := '';
219: l_title per_all_people_f.title%TYPE := '';
220: l_position hr_all_positions_f.name%TYPE := '';
221:
222: BEGIN
223:
224: IF p_item_name = 'CS_PERSON' THEN