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

Line 792: FROM per_time_periods

788: -- added for 3108109
789: BEGIN
790: SELECT end_date
791: INTO l_period_end_date
792: FROM per_time_periods
793: WHERE time_period_id = payroll_control_rec.time_period_id;
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);

Line 797: l_table := 'PER_TIME_PERIODS';

793: WHERE time_period_id = payroll_control_rec.time_period_id;
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
797: l_table := 'PER_TIME_PERIODS';
798: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
799: fnd_message.set_token('VALUE',l_value);
800: fnd_message.set_token('TABLE',l_table);
801: fnd_msg_pub.add;

Line 1359: FROM per_time_periods

1355: BEGIN
1356: --- uncommented the end date for 2663344
1357: SELECT substr(period_name,1,35),end_date
1358: INTO l_period_name, l_period_end_date
1359: FROM per_time_periods
1360: WHERE time_period_id = gl_batch_rec.time_period_id;
1361: EXCEPTION
1362: WHEN NO_DATA_FOUND THEN
1363: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);

Line 1364: l_table := 'PER_TIME_PERIODS';

1360: WHERE time_period_id = gl_batch_rec.time_period_id;
1361: EXCEPTION
1362: WHEN NO_DATA_FOUND THEN
1363: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1364: l_table := 'PER_TIME_PERIODS';
1365: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1366: fnd_message.set_token('VALUE',l_value);
1367: fnd_message.set_token('TABLE',l_table);
1368: fnd_msg_pub.add;

Line 3190: FROM per_time_periods

3186: -- added for 3108109
3187: BEGIN
3188: SELECT end_date
3189: INTO l_period_end_date
3190: FROM per_time_periods
3191: WHERE time_period_id = payroll_control_rec.time_period_id;
3192: EXCEPTION
3193: WHEN NO_DATA_FOUND THEN
3194: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);

Line 3195: l_table := 'PER_TIME_PERIODS';

3191: WHERE time_period_id = payroll_control_rec.time_period_id;
3192: EXCEPTION
3193: WHEN NO_DATA_FOUND THEN
3194: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3195: l_table := 'PER_TIME_PERIODS';
3196: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3197: fnd_message.set_token('VALUE',l_value);
3198: fnd_message.set_token('TABLE',l_table);
3199: fnd_msg_pub.add;

Line 3629: FROM per_time_periods

3625: BEGIN
3626: -- uncommented period end date for 2663344
3627: SELECT substr(period_name ,1,35),end_date
3628: INTO l_period_name ,l_period_end_date
3629: FROM per_time_periods
3630: WHERE time_period_id = gms_batch_rec.time_period_id;
3631: EXCEPTION
3632: WHEN NO_DATA_FOUND THEN
3633: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);

Line 3634: l_table := 'PER_TIME_PERIODS';

3630: WHERE time_period_id = gms_batch_rec.time_period_id;
3631: EXCEPTION
3632: WHEN NO_DATA_FOUND THEN
3633: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3634: l_table := 'PER_TIME_PERIODS';
3635: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3636: fnd_message.set_token('VALUE',l_value);
3637: fnd_message.set_token('TABLE',l_table);
3638: fnd_msg_pub.add;

Line 5267: Per_time_periods ptp

5263: Select distinct pth.template_id,
5264: pth.request_id
5265: From psp_payroll_controls ppc,
5266: Psp_report_templates_h pth,
5267: Per_time_periods ptp
5268: Where ppc.run_id = p_run_id
5269: And ppc.time_period_id = ptp.time_period_id
5270: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date
5271: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_2)) <= ptp.end_date;

Line 5748: from per_time_periods

5744: and source_code = p_source_code;
5745:
5746: cursor get_time_period_name is
5747: select period_name
5748: from per_time_periods
5749: where time_period_id = p_time_period_id;
5750:
5751: cursor get_frp_wf_names is
5752: select distinct wf.name,