DBA Data[Home] [Help]

APPS.PSP_PAYTRN dependencies on PA_EXPENDITURE_TYPES

Line 597: FROM pa_expenditure_types

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

Line 1110: l_table := 'PA_EXPENDITURE_TYPES';

1106: FROM per_people_f
1107: WHERE person_id = l_person_id
1108: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1109: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1110: l_table := 'PA_EXPENDITURE_TYPES';
1111: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
1112: fnd_message.set_token('VALUE',l_value);
1113: fnd_message.set_token('TABLE',l_table);
1114: fnd_message.set_token('BATCH_NAME', NULL);