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

Line 46: from per_assignments_f ASS

42: -- time period start. Used for ITD date, and as a minimum
43: -- for other dimensions.
44: select nvl(greatest(min(ASS.effective_start_date),
45: min(PTP.start_date)), g_eot)
46: from per_assignments_f ASS
47: ,per_time_periods PTP
48: where ASS.assignment_id = p_assignment_id
49: and ASS.effective_start_date <= p_upload_date
50: and PTP.start_date <= p_upload_date

Line 68: ,per_assignments_f ASS

64: cursor csr_period_start is
65: -- Returns the start date of the current period on the upload date.
66: select nvl(PTP.start_date, g_eot)
67: from per_time_periods PTP
68: ,per_assignments_f ASS
69: where ASS.assignment_id = p_assignment_id
70: and p_upload_date between ASS.effective_start_date
71: and ASS.effective_end_date
72: and PTP.payroll_id = ASS.payroll_id