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_OVER_LIMIT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 244: from per_all_assignments_f paf,

240: ,cp_as_of_date in varchar2
241: ,cp_assignid in number) is -- Bug 5717518
242: select /*+ ORDERED */
243: to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id -- Bug 5717518
244: from per_all_assignments_f paf,
245: pay_assignment_actions paa,
246: pay_payroll_actions ppa,
247: pay_action_classifications pac
248: where paf.assignment_id = cp_assignid -- Bug 5717518: New parameter added for performance improvement

Line 487: per_all_assignments_f paf,

483: sqlstr :=
484: 'SELECT paa.rowid
485: FROM pay_payroll_actions ppa,
486: pay_assignment_actions paa,
487: per_all_assignments_f paf,
488: per_all_people_f ppf,
489: hr_organization_units hou,
490: hr_locations_all hl
491: WHERE ppa.payroll_action_id = :pactid

Line 496: from per_all_assignments_f paf2

492: AND paa.payroll_action_id = ppa.payroll_action_id
493: and paf.assignment_id = paa.assignment_id
494: and paf.effective_start_date =
495: (select max(paf2.effective_start_date)
496: from per_all_assignments_f paf2
497: where paf2.assignment_id = paf.assignment_id
498: and paf2.effective_start_date <= ppa.effective_date)
499: and paf.assignment_type = ''E''
500: and ppf.person_id = paf.person_id