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

Line 11: l_value PER_TIME_PERIODS.PRD_INFORMATION1%TYPE;

7: ,p_date_earned DATE ) RETURN NUMBER IS
8:
9:
10:
11: l_value PER_TIME_PERIODS.PRD_INFORMATION1%TYPE;
12: CURSOR get_perc_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
13: SELECT nvl(PRD_INFORMATION1 ,0)
14: FROM PER_TIME_PERIODS ptp
15: WHERE PAYROLL_ID = p_payroll_id

Line 14: FROM PER_TIME_PERIODS ptp

10:
11: l_value PER_TIME_PERIODS.PRD_INFORMATION1%TYPE;
12: CURSOR get_perc_from_ddf(p_payroll_id NUMBER , p_date_earned DATE) IS
13: SELECT nvl(PRD_INFORMATION1 ,0)
14: FROM PER_TIME_PERIODS ptp
15: WHERE PAYROLL_ID = p_payroll_id
16: AND p_date_earned BETWEEN ptp.START_DATE AND ptp.END_DATE;
17:
18: