APPS.PSP_PAYTRN dependencies on GMS_AWARDS_ALL

Line 592: FROM gms_awards_all

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

Line 1089: l_table := 'GMS_AWARDS_ALL';

1085: FROM per_people_f
1086: WHERE person_id = l_person_id
1087: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1088: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1089: l_table := 'GMS_AWARDS_ALL';
1090: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1091: fnd_message.set_token('VALUE',l_value);
1092: fnd_message.set_token('TABLE',l_table);
1093: fnd_message.set_token('BATCH_NAME', NULL);