DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on PA_EXPENDITURE_TYPES

Line 1266: pa_expenditure_types pet

1262: CURSOR expenditure_type_info_cur IS
1263: SELECT NVL(pet.start_date_active, TO_DATE('1800/01/01', 'YYYY/MM/DD')),
1264: NVL(pet.end_date_active, TO_DATE('4712/12/31', 'YYYY/MM/DD'))
1265: FROM gms_allowable_expenditures gae,
1266: pa_expenditure_types pet
1267: WHERE pet.expenditure_type = p_expenditure_type
1268: AND gae.expenditure_type = pet.expenditure_type
1269: AND gae.allowability_schedule_id = l_allowable_schedule_id;
1270: