DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on PA_TASKS

Line 2809: FROM pa_tasks

2805: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
2806:
2807: CURSOR task_number_cur IS
2808: SELECT task_number
2809: FROM pa_tasks
2810: WHERE task_id = gms_interface_rec.task_id;
2811:
2812: CURSOR emp_org_name_cur IS
2813: SELECT name -- Bug 2447912: Removed SUBSTR function

Line 3122: l_table := 'PA_TASKS';

3118: FETCH employee_name_cur INTO l_person_name;
3119: CLOSE employee_name_cur;
3120: -- End of bug fix 1828519
3121: l_value := 'Task Id = '||to_char(gms_interface_rec.task_id);
3122: l_table := 'PA_TASKS';
3123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
3124: fnd_message.set_token('VALUE',l_value);
3125: fnd_message.set_token('TABLE',l_table);
3126: fnd_message.set_token('BATCH_NAME',pc_batch_rec.batch_name); -- Included for bug fix 1828519