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.HXT_TRAN_PA dependencies on PER_PAY_PROPOSALS

Line 357: per_pay_proposals pro,

353: FROM hxt_det_hours_worked_x det,
354: hxt_sum_hours_worked_x shw,
355: per_assignments_f asg,
356: per_pay_bases ppb,
357: per_pay_proposals pro,
358: hr_organization_units_v org,
359: hr_lookups fcl,
360: hr_lookups fcl2,
361: pay_element_types_f pay,

Line 376: FROM per_pay_proposals pro2

372: AND asg.organization_id = org.organization_id
373: AND pro.assignment_id = det.assignment_id
374: AND pro.approved = 'Y'
375: AND pro.change_date = (SELECT MAX(pro2.change_date)
376: FROM per_pay_proposals pro2
377: WHERE pro2.assignment_id = det.assignment_id
378: AND pro2.approved = 'Y'
379: AND det.date_worked >= pro2.change_date)
380: AND det.element_type_id = pay.element_type_id