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_UK_BAL_UPLOAD dependencies on PER_TIME_PERIODS

Line 121: from per_time_periods PTP

117: ,p_upload_date date
118: ,p_stat_yr_start_date date
119: ) is
120: select nvl(min(PTP.regular_payment_date), END_OF_TIME)
121: from per_time_periods PTP
122: ,per_assignments_f ASS
123: where ASS.assignment_id = p_assignment_id
124: and p_upload_date between ASS.effective_start_date
125: and ASS.effective_end_date

Line 137: from per_time_periods PTP

133: p_assignment_id number
134: ,p_upload_date date
135: ) is
136: select nvl(PTP.start_date, END_OF_TIME)
137: from per_time_periods PTP
138: ,per_assignments_f ASS
139: where ASS.assignment_id = p_assignment_id
140: and p_upload_date between ASS.effective_start_date
141: and ASS.effective_end_date

Line 160: ,per_time_periods PTP

156: ) is
157: select nvl(greatest(min(ASS.effective_start_date),
158: min(PTP.start_date)), END_OF_TIME)
159: from per_assignments_f ASS
160: ,per_time_periods PTP
161: where ASS.assignment_id = p_assignment_id
162: and ASS.effective_start_date <= p_upload_date
163: and PTP.start_date <= p_upload_date
164: and PTP.payroll_id = ASS.payroll_id;