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

Line 44: from per_all_assignments_f asg,

40: ptp.time_period_id
41: into l_assignment_rec.business_group_id,
42: l_assignment_rec.payroll_id,
43: l_assignment_rec.time_period_id
44: from per_all_assignments_f asg,
45: per_time_periods ptp
46: where asg.assignment_id = p_assignment_id
47: and p_effective_date
48: between asg.effective_start_date and asg.effective_end_date

Line 220: from per_all_assignments_f asg,

216: , 24))
217: into l_assignment_action_id
218: from (
219: select asg2.assignment_id
220: from per_all_assignments_f asg,
221: per_all_assignments_f asg2
222: where asg.assignment_id = p_assignment_id
223: and p_effective_date
224: between asg.effective_start_date and asg.effective_end_date

Line 221: per_all_assignments_f asg2

217: into l_assignment_action_id
218: from (
219: select asg2.assignment_id
220: from per_all_assignments_f asg,
221: per_all_assignments_f asg2
222: where asg.assignment_id = p_assignment_id
223: and p_effective_date
224: between asg.effective_start_date and asg.effective_end_date
225: and asg2.person_id = asg.person_id

Line 247: from per_all_assignments_f asg,

243: , 16))
244: into l_assignment_action_id
245: from (
246: select asg2.assignment_id
247: from per_all_assignments_f asg,
248: per_all_assignments_f asg2
249: where asg.assignment_id = p_assignment_id
250: and p_effective_date
251: between asg.effective_start_date and asg.effective_end_date

Line 248: per_all_assignments_f asg2

244: into l_assignment_action_id
245: from (
246: select asg2.assignment_id
247: from per_all_assignments_f asg,
248: per_all_assignments_f asg2
249: where asg.assignment_id = p_assignment_id
250: and p_effective_date
251: between asg.effective_start_date and asg.effective_end_date
252: and asg2.person_id = asg.person_id

Line 328: from per_all_assignments_f asg,

324: , 16))
325: into l_assignment_action_id
326: from (
327: select asg2.assignment_id
328: from per_all_assignments_f asg,
329: per_all_assignments_f asg2
330: where asg.assignment_id = p_assignment_id
331: and p_effective_date
332: between asg.effective_start_date and asg.effective_end_date

Line 329: per_all_assignments_f asg2

325: into l_assignment_action_id
326: from (
327: select asg2.assignment_id
328: from per_all_assignments_f asg,
329: per_all_assignments_f asg2
330: where asg.assignment_id = p_assignment_id
331: and p_effective_date
332: between asg.effective_start_date and asg.effective_end_date
333: and asg2.person_id = asg.person_id