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

Line 356: select end_date from per_time_periods

352: IS
353:
354: CURSOR csr_first_end_date
355: IS
356: select end_date from per_time_periods
357: where payroll_id = p_PAYROLL_ID
358: and to_char(end_date,'YYYY') = to_char(p_CURR_PAY_END_DATE,'YYYY')
359: and rownum < 2
360: order by end_date;

Line 364: select count(*) from per_time_periods

360: order by end_date;
361:
362: cursor csr_Get_pay_run(l_mdate date,l_first_end_date date)
363: is
364: select count(*) from per_time_periods
365: where payroll_id = p_PAYROLL_ID
366: and to_char(end_date,'YYYY') = to_char(l_first_end_date,'YYYY')
367: and p_CURR_PAY_END_DATE >= end_date --DBI Item, Current Payroll End Date
368: and l_mdate <= end_date; --Variable, Current Year First Period End Date OR Join Date, whichever is Max