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

Line 2646: from per_time_periods pt

2642:
2643: CURSOR get_period_dates (l_date_earned date,
2644: l_payroll_id number) IS
2645: select start_date, end_date
2646: from per_time_periods pt
2647: where payroll_id = l_payroll_id
2648: and l_date_earned between start_date and end_date;
2649:
2650: CURSOR get_salary_basis(l_date_earned date,

Line 3332: from per_time_periods ptp

3328: CURSOR csr_pay_period(p_date_earned date
3329: ,p_payroll_id number) is
3330: select ptp.start_date
3331: ,ptp.end_date
3332: from per_time_periods ptp
3333: where ptp.payroll_id = p_payroll_id
3334: and p_date_earned between ptp.start_date and ptp.end_date;
3335:
3336: -- Get ATD, LSPD, FPD for the Terminated EE