DBA Data[Home] [Help]

APPS.PSP_PAYTRN dependencies on PA_EXPENDITURE_TYPES

Line 599: FROM pa_expenditure_types

595: WHERE award_id = l_or_award_id;
596:
597: CURSOR expenditure_type_cur IS
598: SELECT expenditure_type
599: FROM pa_expenditure_types
600: WHERE expenditure_type = l_or_expenditure_type;
601:
602: BEGIN
603:

Line 1143: l_table := 'PA_EXPENDITURE_TYPES';

1139: FROM per_people_f
1140: WHERE person_id = l_person_id
1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';
1144: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1145: fnd_message.set_token('VALUE',l_value);
1146: fnd_message.set_token('TABLE',l_table);
1147: fnd_message.set_token('BATCH_NAME', NULL);