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.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 306: -- Cursor to retrieve end_dates from per_time_periods

302: AND effective_start_date = c_effective_start_date
303: AND effective_end_date = c_effective_end_date;
304:
305: -- Bug Fix 5101756
306: -- Cursor to retrieve end_dates from per_time_periods
307: CURSOR csr_get_end_date (
308: c_assignment_id NUMBER,
309: c_effective_start_date DATE,
310: c_effective_end_date DATE

Line 314: FROM per_time_periods ptp,

310: c_effective_end_date DATE
311: )
312: IS
313: SELECT DISTINCT (ptp.end_date) end_date
314: FROM per_time_periods ptp,
315: pay_payroll_actions ppa,
316: pay_assignment_actions paa
317: WHERE ptp.time_period_id = ppa.time_period_id
318: AND ppa.effective_date BETWEEN ptp.start_date