APPS.PSP_SUM_ADJ dependencies on PER_TIME_PERIODS

Line 1208: FROM per_time_periods

1204:
1205: -- Included the following cursors here for referring local variables for bug fix 1765678
1206: CURSOR time_period_cur IS
1207: SELECT period_name, end_date
1208: FROM per_time_periods
1209: WHERE time_period_id = gl_batch_rec.time_period_id;
1210:
1211: /*** Commented this as part of bug fix 2916848
1212: CURSOR currency_code_cur IS

Line 1288: l_table := 'PER_TIME_PERIODS';

1284: FETCH employee_name_cur INTO l_person_name;
1285: CLOSE employee_name_cur;
1286: -- End of bug fix 1828519
1287: l_value := 'Time Period Id = '||to_char(gl_batch_rec.time_period_id);
1288: l_table := 'PER_TIME_PERIODS';
1289: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1290: fnd_message.set_token('VALUE',l_value);
1291: fnd_message.set_token('TABLE',l_table);
1292: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519

Line 2798: FROM per_time_periods

2794:
2795: -- Included the following cursor here for acessing local variables for bug fix 1765678
2796: CURSOR time_period_cur IS
2797: SELECT period_name, end_date
2798: FROM per_time_periods
2799: WHERE time_period_id = gms_batch_rec.time_period_id;
2800:
2801: CURSOR employee_cur IS
2802: SELECT employee_number

Line 2981: l_table := 'PER_TIME_PERIODS';

2977: FETCH employee_name_cur INTO l_person_name;
2978: CLOSE employee_name_cur;
2979: -- End of bug fix 1828519
2980: l_value := 'Time Period Id = '||to_char(gms_batch_rec.time_period_id);
2981: l_table := 'PER_TIME_PERIODS';
2982: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
2983: fnd_message.set_token('VALUE',l_value);
2984: fnd_message.set_token('TABLE',l_table);
2985: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519