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_KW_BAL_UPLOAD dependencies on PER_ASSIGNMENTS_F

Line 65: ,per_assignments_f ASS

61: ,p_upload_date date
62: ) is
63: select nvl(PTP.start_date, END_OF_TIME)
64: from per_time_periods PTP
65: ,per_assignments_f ASS
66: where ASS.assignment_id = p_assignment_id
67: and p_upload_date between ASS.effective_start_date
68: and ASS.effective_end_date
69: and PTP.payroll_id = ASS.payroll_id

Line 81: FROM per_assignments_f ass

77: p_assignment_id NUMBER,
78: p_upload_date DATE
79: ) IS
80: SELECT NVL(MIN(ass.effective_start_date), END_OF_TIME)
81: FROM per_assignments_f ass
82: WHERE ass.assignment_id = p_assignment_id
83: AND ass.payroll_id IS NOT NULL
84: AND ass.effective_start_date <= p_upload_date;
85: