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

Line 125: from per_time_periods ptp,

121: hr_utility.set_location(c_proc, 20);
122: --
123: select nvl(min(ptp2.start_date), END_OF_TIME)
124: into l_ptp_start_date
125: from per_time_periods ptp,
126: per_time_periods ptp2
127: where ptp.payroll_id = l_payroll_id
128: and p_upload_date
129: between ptp.start_date and ptp.end_date

Line 126: per_time_periods ptp2

122: --
123: select nvl(min(ptp2.start_date), END_OF_TIME)
124: into l_ptp_start_date
125: from per_time_periods ptp,
126: per_time_periods ptp2
127: where ptp.payroll_id = l_payroll_id
128: and p_upload_date
129: between ptp.start_date and ptp.end_date
130: and ptp2.payroll_id = ptp.payroll_id