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_GB_STUDENT_LOANS_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 562: per_time_period_types ptpt

558: CURSOR get_freq IS
559: SELECT ptpt.number_per_fiscal_year
560: FROM per_all_assignments_f papf,
561: pay_all_payrolls_f pap,
562: per_time_period_types ptpt
563: WHERE papf.assignment_id = p_assignment_id
564: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
565: AND pap.payroll_id = papf.payroll_id
566: AND p_date_earned BETWEEN pap.effective_start_date and pap.effective_end_date

Line 569: l_freq per_time_period_types.number_per_fiscal_year%TYPE;

565: AND pap.payroll_id = papf.payroll_id
566: AND p_date_earned BETWEEN pap.effective_start_date and pap.effective_end_date
567: AND pap.period_type=ptpt.period_type;
568:
569: l_freq per_time_period_types.number_per_fiscal_year%TYPE;
570: l_proc VARCHAR2(50) ;
571:
572: BEGIN
573: l_proc := g_package_functions || 'get_current_freq';

Line 1048: per_time_period_types ptpt

1044: --
1045: CURSOR get_freq IS
1046: SELECT number_per_fiscal_year
1047: FROM per_time_periods ptp,
1048: per_time_period_types ptpt
1049: WHERE p_date_earned BETWEEN ptp.start_date AND ptp.end_Date
1050: AND ptp.payroll_id = l_payroll_id
1051: AND ptp.period_type = ptpt.period_type;
1052: --