DBA Data[Home] [Help]

APPS.PSP_ENC_PRE_PROCESS dependencies on GMS_ALLOWABLE_EXPENDITURES

Line 1265: FROM gms_allowable_expenditures gae,

1261: /* Cursor is used to fetch expenditure type date and to validate expenditure type */
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;