APPS.PSP_SUM_ADJ dependencies on PER_TIME_PERIODS

Line 1300: FROM per_time_periods

1296:
1297: -- Included the following cursors here for referring local variables for bug fix 1765678
1298: CURSOR time_period_cur IS
1299: SELECT period_name, end_date
1300: FROM per_time_periods
1301: WHERE time_period_id = gl_batch_rec.time_period_id;
1302:
1303: /*** Commented this as part of bug fix 2916848
1304: CURSOR currency_code_cur IS

Line 1384: l_table := 'PER_TIME_PERIODS';

1380: FETCH employee_name_cur INTO l_person_name;
1381: CLOSE employee_name_cur;
1382: -- End of bug fix 1828519
1383: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1384: l_table := 'PER_TIME_PERIODS';
1385: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1386: fnd_message.set_token('VALUE',l_value);
1387: fnd_message.set_token('TABLE',l_table);
1388: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

Line 2942: FROM per_time_periods

2938:
2939: -- Included the following cursor here for acessing local variables for bug fix 1765678
2940: CURSOR time_period_cur IS
2941: SELECT period_name, end_date
2942: FROM per_time_periods
2943: WHERE time_period_id = gms_batch_rec.time_period_id;
2944:
2945: CURSOR employee_cur IS
2946: SELECT employee_number

Line 3133: l_table := 'PER_TIME_PERIODS';

3129: FETCH employee_name_cur INTO l_person_name;
3130: CLOSE employee_name_cur;
3131: -- End of bug fix 1828519
3132: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
3133: l_table := 'PER_TIME_PERIODS';
3134: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3135: fnd_message.set_token('VALUE',l_value);
3136: fnd_message.set_token('TABLE',l_table);
3137: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519