1187: pa_expenditure_types
1188: per_organization_units
1189: needs to be replaced with
1190: pa_projects_expend_v
1191: pa_expenditure_types_expend_v
1192: pa_organizations_expend_v
1193: or else the projects validation would fail.
1194: */
1195: /* Bug 2892199 Added expenditure item date validation */
1215: end;
1216:
1217: begin
1218: SELECT 'Y' into x_valid2
1219: FROM pa_expenditure_types_expend_v pet
1220: WHERE pet.expenditure_type = x_expenditure_type
1221: AND pet.system_linkage_function = 'VI';
1222: exception
1223: when no_data_found then