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 3055: from per_time_periods pt

3051:
3052: CURSOR get_period_dates (l_date_earned date,
3053: l_payroll_id number) IS
3054: select start_date, end_date
3055: from per_time_periods pt
3056: where payroll_id = l_payroll_id
3057: and l_date_earned between start_date and end_date;
3058:
3059: CURSOR get_salary_basis(l_date_earned date,

Line 3751: from per_time_periods ptp

3747: CURSOR csr_pay_period(p_date_earned date
3748: ,p_payroll_id number) is
3749: select ptp.start_date
3750: ,ptp.end_date
3751: from per_time_periods ptp
3752: where ptp.payroll_id = p_payroll_id
3753: and p_date_earned between ptp.start_date and ptp.end_date;
3754:
3755: -- Get ATD, LSPD, FPD for the Terminated EE