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 853: from per_time_periods ptpf,

849: select ptpf.end_date + 1,
850: ptpl.end_date
851: into l_report_start,
852: l_report_end
853: from per_time_periods ptpf,
854: per_time_periods ptpl
855: where ptpl.payroll_id = l_assignment.payroll_id
856: and l_report_date between ptpl.start_date and ptpl.end_date
857: and ptpf.payroll_id = l_assignment.payroll_id

Line 854: per_time_periods ptpl

850: ptpl.end_date
851: into l_report_start,
852: l_report_end
853: from per_time_periods ptpf,
854: per_time_periods ptpl
855: where ptpl.payroll_id = l_assignment.payroll_id
856: and l_report_date between ptpl.start_date and ptpl.end_date
857: and ptpf.payroll_id = l_assignment.payroll_id
858: and add_months(l_report_date, -12) + 1 between ptpf.start_date and ptpf.end_date;

Line 875: from per_time_periods ptpl

871: when no_data_found then
872: begin
873: select ptpl.end_date
874: into l_report_end
875: from per_time_periods ptpl
876: where ptpl.payroll_id = l_assignment.payroll_id
877: and p_report_date between ptpl.start_date and ptpl.end_date;
878:
879: exception

Line 4826: from per_time_periods ptpf,

4822: select ptpf.end_date + 1,
4823: ptpl.end_date
4824: into l_report_start,
4825: l_report_end
4826: from per_time_periods ptpf,
4827: per_time_periods ptpl
4828: where ptpl.payroll_id = l_assignment.payroll_id
4829: and l_report_date between ptpl.start_date and ptpl.end_date
4830: and ptpf.payroll_id = l_assignment.payroll_id

Line 4827: per_time_periods ptpl

4823: ptpl.end_date
4824: into l_report_start,
4825: l_report_end
4826: from per_time_periods ptpf,
4827: per_time_periods ptpl
4828: where ptpl.payroll_id = l_assignment.payroll_id
4829: and l_report_date between ptpl.start_date and ptpl.end_date
4830: and ptpf.payroll_id = l_assignment.payroll_id
4831: and add_months(l_report_date, -12) + 1 between ptpf.start_date and ptpf.end_date;

Line 4848: from per_time_periods ptpl

4844: when no_data_found then
4845: begin
4846: select ptpl.end_date
4847: into l_report_end
4848: from per_time_periods ptpl
4849: where ptpl.payroll_id = l_assignment.payroll_id
4850: and p_report_date between ptpl.start_date and ptpl.end_date;
4851:
4852: exception

Line 6231: from per_time_periods ptpf,

6227: select ptpf.end_date + 1,
6228: ptpl.end_date
6229: into l_report_start,
6230: l_report_end
6231: from per_time_periods ptpf,
6232: per_time_periods ptpl
6233: where ptpl.payroll_id = l_assignment.payroll_id
6234: and l_report_date between ptpl.start_date and ptpl.end_date
6235: and ptpf.payroll_id = l_assignment.payroll_id

Line 6232: per_time_periods ptpl

6228: ptpl.end_date
6229: into l_report_start,
6230: l_report_end
6231: from per_time_periods ptpf,
6232: per_time_periods ptpl
6233: where ptpl.payroll_id = l_assignment.payroll_id
6234: and l_report_date between ptpl.start_date and ptpl.end_date
6235: and ptpf.payroll_id = l_assignment.payroll_id
6236: and add_months(l_report_date, -12) + 1 between ptpf.start_date and ptpf.end_date;

Line 6253: from per_time_periods ptpl

6249: when no_data_found then
6250: begin
6251: select ptpl.end_date
6252: into l_report_end
6253: from per_time_periods ptpl
6254: where ptpl.payroll_id = l_assignment.payroll_id
6255: and p_report_date between ptpl.start_date and ptpl.end_date;
6256:
6257: exception