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 851: FROM per_time_periods

847: -- added for 3108109
848: BEGIN
849: SELECT end_date
850: INTO l_period_end_date
851: FROM per_time_periods
852: WHERE time_period_id = payroll_control_rec.time_period_id;
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);

Line 856: l_table := 'PER_TIME_PERIODS';

852: WHERE time_period_id = payroll_control_rec.time_period_id;
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
856: l_table := 'PER_TIME_PERIODS';
857: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
858: fnd_message.set_token('VALUE',l_value);
859: fnd_message.set_token('TABLE',l_table);
860: fnd_msg_pub.add;

Line 1446: FROM per_time_periods

1442: BEGIN
1443: --- uncommented the end date for 2663344
1444: SELECT substr(period_name,1,35),end_date
1445: INTO l_period_name, l_period_end_date
1446: FROM per_time_periods
1447: WHERE time_period_id = gl_batch_rec.time_period_id;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);

Line 1451: l_table := 'PER_TIME_PERIODS';

1447: WHERE time_period_id = gl_batch_rec.time_period_id;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1451: l_table := 'PER_TIME_PERIODS';
1452: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1453: fnd_message.set_token('VALUE',l_value);
1454: fnd_message.set_token('TABLE',l_table);
1455: fnd_msg_pub.add;

Line 3375: FROM per_time_periods

3371: -- added for 3108109
3372: BEGIN
3373: SELECT end_date
3374: INTO l_period_end_date
3375: FROM per_time_periods
3376: WHERE time_period_id = payroll_control_rec.time_period_id;
3377: EXCEPTION
3378: WHEN NO_DATA_FOUND THEN
3379: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);

Line 3380: l_table := 'PER_TIME_PERIODS';

3376: WHERE time_period_id = payroll_control_rec.time_period_id;
3377: EXCEPTION
3378: WHEN NO_DATA_FOUND THEN
3379: l_value := 'Time Period Id = '||to_char(payroll_control_rec.time_period_id);
3380: l_table := 'PER_TIME_PERIODS';
3381: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3382: fnd_message.set_token('VALUE',l_value);
3383: fnd_message.set_token('TABLE',l_table);
3384: fnd_msg_pub.add;

Line 3824: FROM per_time_periods

3820: BEGIN
3821: -- uncommented period end date for 2663344
3822: SELECT substr(period_name ,1,35),end_date
3823: INTO l_period_name ,l_period_end_date
3824: FROM per_time_periods
3825: WHERE time_period_id = gms_batch_rec.time_period_id;
3826: EXCEPTION
3827: WHEN NO_DATA_FOUND THEN
3828: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);

Line 3829: l_table := 'PER_TIME_PERIODS';

3825: WHERE time_period_id = gms_batch_rec.time_period_id;
3826: EXCEPTION
3827: WHEN NO_DATA_FOUND THEN
3828: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3829: l_table := 'PER_TIME_PERIODS';
3830: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3831: fnd_message.set_token('VALUE',l_value);
3832: fnd_message.set_token('TABLE',l_table);
3833: fnd_msg_pub.add;

Line 5690: Per_time_periods ptp

5686: Select distinct pth.template_id,
5687: pth.request_id
5688: From psp_payroll_controls ppc,
5689: Psp_report_templates_h pth,
5690: Per_time_periods ptp
5691: Where ppc.run_id = p_run_id
5692: And ppc.time_period_id = ptp.time_period_id
5693: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_3)) >= ptp.start_date
5694: And fnd_date.canonical_to_date(fnd_date.date_to_canonical(pth.parameter_value_2)) <= ptp.end_date;

Line 6171: from per_time_periods

6167: and source_code = p_source_code;
6168:
6169: cursor get_time_period_name is
6170: select period_name
6171: from per_time_periods
6172: where time_period_id = p_time_period_id;
6173:
6174: cursor get_frp_wf_names is
6175: select distinct wf.name,