Autoaccounting rule being cut off
Trying to change the auto accounting rule in Projects from:
select decode(pt.project_type, 'OH INDIRECT GOVT', :1||'.OH','CONTRA R&D',:2,:3)
from pa_expenditures_all pae,
pa_expenditure_items_all paei,
pa_expenditure_types et,
pa_projects_all p,
pa_tasks t,
pa_project_types_all pt
where
paei.expenditure_item_id = :4
and pae.expenditure_id = paei.expenditure_id
and paei.task_id = t.task_id
and t.project_id = p.project_id
and p.project_type = pt. project_type
and paei.expenditure_type = et.expenditure_type
and p.org_id = pt.org_id
to below:
select decode(pt.project_type, 'OH INDIRECT GOVT', :1||'.OH','CONTRA R&D',:2,'SBR UNFUNDED PROJECT','13650',:3)