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_RETRO_PA dependencies on PER_PAY_PROPOSALS

Line 322: per_pay_proposals pro,

318: asg.assignment_number,
319: det.parent_id,
320: det.element_type_id
321: FROM hxt_det_hours_worked_x det,
322: per_pay_proposals pro,
323: per_pay_bases ppb,
324: hr_lookups fcl,
325: hr_lookups fcl2,
326: per_assignments_f asg,

Line 342: FROM per_pay_proposals pro2

338: AND asg.organization_id = org.organization_id
339: AND det.assignment_id = pro.assignment_id
340: AND pro.approved = 'Y'
341: AND pro.change_date = (SELECT MAX(pro2.change_date)
342: FROM per_pay_proposals pro2
343: WHERE pro2.assignment_id = det.assignment_id
344: AND pro2.approved = 'Y'
345: AND det.date_worked >= pro2.change_date)
346: AND det.element_type_id = pay.element_type_id

Line 425: per_pay_proposals pro,

421: det.element_type_id, --SIR162
422: asg.assignment_id,
423: asg.assignment_number
424: FROM hxt_det_hours_worked_f det,
425: per_pay_proposals pro,
426: per_pay_bases ppb,
427: hr_lookups fcl, --FORMS60
428: hr_lookups fcl2, --FORMS60
429: per_assignments_f asg,

Line 445: FROM per_pay_proposals pro2

441: AND asg.organization_id = org.organization_id
442: AND asg.assignment_id = pro.assignment_id
443: AND pro.approved = 'Y'
444: AND pro.change_date = (SELECT MAX(pro2.change_date)
445: FROM per_pay_proposals pro2
446: WHERE pro2.assignment_id = det.assignment_id
447: AND pro2.approved = 'Y'
448: AND det.date_worked >= pro2.change_date)
449: AND payt.element_type_id = pay.element_type_id