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

Line 25: per_time_periods.

21: date for dimensions with GRE context
22: during Purge Process.
23: 115.11 rdhingra 22-Mar-2006 Bug 5042715: Modified cursor
24: c_td_start_date to remove FTS on
25: per_time_periods.
26: 115.10 kvsankar 11-Aug-2005 Enabled the dimension '_ASG_GRE_TD_TDPTD'
27: for Balance Initialization.
28: Modified the procedure 'EXPIRY_DATE'
29: to return the start date of the Time

Line 227: from per_time_periods PTP

223: p_assignment_id number
224: ,p_upload_date date
225: ) is
226: select nvl(PTP.start_date, END_OF_TIME)
227: from per_time_periods PTP
228: ,per_assignments_f ASS
229: where ASS.assignment_id = p_assignment_id
230: and p_upload_date between ASS.effective_start_date
231: and ASS.effective_end_date

Line 251: ,per_time_periods PTP

247: min(PTP.start_date)),
248: END_OF_TIME)
249: from per_assignments_f ASS
250: ,hr_soft_coding_Keyflex SCL
251: ,per_time_periods PTP
252: where ASS.assignment_id = p_assignment_id
253: and ASS.effective_start_date <= p_upload_date
254: and ASS.effective_end_date >= p_expiry_date
255: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id

Line 281: ,per_time_periods PTP

277: ) is
278: select nvl(greatest (min(ASG.effective_start_date), min(PTP.start_date)),
279: END_OF_TIME)
280: from per_assignments_f ASG
281: ,per_time_periods PTP
282: where ASG.assignment_id = p_assignment_id
283: and ASG.effective_start_date <= p_upload_date
284: and PTP.payroll_id = ASG.payroll_id
285: and PTP.start_date <= p_upload_date

Line 310: ,per_time_periods PTP

306: select nvl(greatest(min(ASS.effective_start_date), min(PTP.start_date)),
307: END_OF_TIME)
308: from per_assignments_f ASS
309: ,hr_soft_coding_keyflex SCL
310: ,per_time_periods PTP
311: where ASS.assignment_id = p_assignment_id
312: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id
313: and ASS.effective_start_date <= p_upload_date
314: and SCL.segment1 = to_char(p_tax_unit_id)

Line 335: ,per_time_periods PTP

331: select nvl(greatest(min(ASS.effective_start_date),
332: min(PTP.start_date), p_expiry_date),
333: END_OF_TIME)
334: from per_assignments_f ASS
335: ,per_time_periods PTP
336: where ASS.assignment_id = p_assignment_id
337: and ASS.effective_start_date <= p_upload_date
338: and ASS.effective_end_date >= p_expiry_date
339: and PTP.payroll_id = ASS.payroll_id

Line 362: from per_time_periods ptp

358: -- Cursor to get the Time Definition Start Date
359: cursor c_td_start_date(p_time_definition_id number
360: ,p_upload_date date) is
361: select ptp.start_date
362: from per_time_periods ptp
363: where ptp.time_definition_id = p_time_definition_id
364: and p_upload_date between ptp.start_date
365: and ptp.end_date
366: and ptp.time_definition_id is not null