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_JP_DEF_REPORT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 259: per_periods_of_service ppos

255: p_sqlstr :=
256: 'select distinct ppos.person_id
257: from pay_payroll_actions ppa,
258: per_all_people_f pp,
259: per_periods_of_service ppos
260: where ppa.payroll_action_id = :payroll_action_id
261: and pp.business_group_id = ppa.business_group_id + 0
262: and ppos.person_id = pp.person_id
263: and ppos.business_group_id + 0 = pp.business_group_id

Line 305: from per_periods_of_service ppos,

301: select /*+ ORDERED */
302: pjda.assignment_id,
303: pjda.assignment_action_id,
304: pjda.effective_date
305: from per_periods_of_service ppos,
306: per_all_assignments_f pa,
307: pay_assignment_actions paa,
308: pay_jp_def_assact_v pjda,
309: pay_jp_def_emp_v pjde

Line 333: from per_periods_of_service ppos,

329: pjda.assignment_id,
330: pjda.assignment_action_id,
331: pjda.effective_date,
332: hasa.include_or_exclude
333: from per_periods_of_service ppos,
334: per_all_assignments_f pa,
335: pay_assignment_actions paa,
336: hr_assignment_set_amendments hasa,
337: pay_jp_def_assact_v pjda,