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

Line 21: per_all_assignments_f asg

17: select
18: greatest(min(asg.effective_start_date)
19: ,min(ptp.start_date))
20: from
21: per_all_assignments_f asg
22: ,per_time_periods ptp
23: where asg.assignment_id = p_assignment_id
24: and ptp.payroll_id = asg.payroll_id
25: and ptp.start_date <= asg.effective_end_date;

Line 81: FROM per_all_assignments_f ass

77: (p_assignment_id NUMBER
78: ,p_upload_date DATE
79: ) IS
80: SELECT ptp.start_date
81: FROM per_all_assignments_f ass
82: ,per_time_periods ptp
83: WHERE ass.assignment_id = p_assignment_id
84: AND ass.effective_start_date <= p_upload_date
85: AND ass.effective_end_date >= p_upload_date