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.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_TIME_PERIODS

Line 806: from per_time_periods ptpf,

802: select ptpf.end_date + 1,
803: ptpl.end_date
804: into l_report_start,
805: l_report_end
806: from per_time_periods ptpf,
807: per_time_periods ptpl
808: where ptpl.payroll_id = l_assignment.payroll_id
809: and l_report_date between ptpl.start_date and ptpl.end_date
810: and ptpf.payroll_id = l_assignment.payroll_id

Line 807: per_time_periods ptpl

803: ptpl.end_date
804: into l_report_start,
805: l_report_end
806: from per_time_periods ptpf,
807: per_time_periods ptpl
808: where ptpl.payroll_id = l_assignment.payroll_id
809: and l_report_date between ptpl.start_date and ptpl.end_date
810: and ptpf.payroll_id = l_assignment.payroll_id
811: and add_months(l_report_date, -12) + 1 between ptpf.start_date and ptpf.end_date;

Line 828: from per_time_periods ptpl

824: when no_data_found then
825: begin
826: select ptpl.end_date
827: into l_report_end
828: from per_time_periods ptpl
829: where ptpl.payroll_id = l_assignment.payroll_id
830: and p_report_date between ptpl.start_date and ptpl.end_date;
831:
832: exception

Line 4703: from per_time_periods ptpf,

4699: select ptpf.end_date + 1,
4700: ptpl.end_date
4701: into l_report_start,
4702: l_report_end
4703: from per_time_periods ptpf,
4704: per_time_periods ptpl
4705: where ptpl.payroll_id = l_assignment.payroll_id
4706: and l_report_date between ptpl.start_date and ptpl.end_date
4707: and ptpf.payroll_id = l_assignment.payroll_id

Line 4704: per_time_periods ptpl

4700: ptpl.end_date
4701: into l_report_start,
4702: l_report_end
4703: from per_time_periods ptpf,
4704: per_time_periods ptpl
4705: where ptpl.payroll_id = l_assignment.payroll_id
4706: and l_report_date between ptpl.start_date and ptpl.end_date
4707: and ptpf.payroll_id = l_assignment.payroll_id
4708: and add_months(l_report_date, -12) + 1 between ptpf.start_date and ptpf.end_date;

Line 4725: from per_time_periods ptpl

4721: when no_data_found then
4722: begin
4723: select ptpl.end_date
4724: into l_report_end
4725: from per_time_periods ptpl
4726: where ptpl.payroll_id = l_assignment.payroll_id
4727: and p_report_date between ptpl.start_date and ptpl.end_date;
4728:
4729: exception