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.HR_JP_AST_UTILITY_PKG dependencies on PER_ALL_PEOPLE_F

Line 544: per_all_people_f per

540: and asg2.payroll_id +0 = asg1.payroll_id
541: group by asg2.assignment_id
542: ) v,
543: per_all_assignments_f asg3,
544: per_all_people_f per
545: --
546: -- Assignment information must be retrieved by Batch Line Upload Date.
547: --
548: where asg3.assignment_id = v.assignment_id

Line 588: per_all_people_f per

584: and asg2.payroll_id + 0 = asg1.payroll_id
585: group by asg2.assignment_id
586: ) v,
587: per_all_assignments_f asg3,
588: per_all_people_f per
589: where asg3.assignment_id = v.assignment_id
590: and asg3.effective_start_date = v.effective_start_date
591: and per.person_id = asg3.person_id
592: and greatest(asg3.effective_start_date, p_start_date)

Line 633: per_all_people_f per

629: and nvl(asa.include_or_exclude, 'I') = 'I'
630: group by asg2.assignment_id
631: ) v,
632: per_all_assignments_f asg3,
633: per_all_people_f per
634: where asg3.assignment_id = v.assignment_id
635: and asg3.effective_start_date = v.effective_start_date
636: and per.person_id = asg3.person_id
637: and greatest(asg3.effective_start_date, p_start_date)