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

Line 531: per_time_periods ptp,

527: SELECT
528: ptp.end_date,
529: ptp.period_name
530: FROM
531: per_time_periods ptp,
532: per_all_assignments_f paa
533: WHERE paa.assignment_id = asg_id
534: AND ptp.end_date between paa.effective_start_date
535: AND paa.effective_end_date

Line 1139: ,per_time_periods ptp

1135: ,concat(concat(ptp.period_num,' '),TO_CHAR(ptp.START_DATE,'YYYY')) period_name
1136: ,ptp.start_date start_date
1137: FROM pay_payroll_actions ppa
1138: ,pay_assignment_actions paa
1139: ,per_time_periods ptp
1140: WHERE paa.payroll_action_id = ppa.payroll_action_id
1141: AND paa.action_status IN ('C','S')
1142: AND ppa.effective_date BETWEEN l_reporting_start_date
1143: AND l_reporting_date

Line 1171: ,per_time_periods ptp

1167: ,concat(concat('R '||ptp.period_num,' '),TO_CHAR(ptp.START_DATE,'YYYY')) period_name
1168: FROM pay_payroll_actions ppa
1169: ,pay_assignment_actions paa
1170: ,pay_run_results prr
1171: ,per_time_periods ptp
1172: WHERE paa.payroll_action_id = ppa.payroll_action_id
1173: AND paa.source_action_id IS NOT NULL
1174: AND paa.action_status IN ('C','S')
1175: AND prr.assignment_action_id = paa.assignment_action_id