APPS.PSP_PAYTRN dependencies on GMS_AWARDS_ALL

Line 594: FROM gms_awards_all

590: WHERE task_id = l_or_task_id;
591:
592: CURSOR award_id_cur IS
593: SELECT award_number
594: FROM gms_awards_all
595: WHERE award_id = l_or_award_id;
596:
597: CURSOR expenditure_type_cur IS
598: SELECT expenditure_type

Line 1122: l_table := 'GMS_AWARDS_ALL';

1118: FROM per_people_f
1119: WHERE person_id = l_person_id
1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';
1123: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1124: fnd_message.set_token('VALUE',l_value);
1125: fnd_message.set_token('TABLE',l_table);
1126: fnd_message.set_token('BATCH_NAME', NULL);