SELECT pap.project_id ,pap.segment1 ,pap.name ,pap.org_id from pa_projects pap WHERE pap.template_flag <> 'Y' and pa_project_utils.check_prj_stus_action_allowed(pap.project_status_code,'NEW_TXNS')='Y'
View Text - HTML Formatted
SELECT PAP.PROJECT_ID , PAP.SEGMENT1 , PAP.NAME , PAP.ORG_ID FROM PA_PROJECTS PAP WHERE PAP.TEMPLATE_FLAG <> 'Y' AND PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED(PAP.PROJECT_STATUS_CODE , 'NEW_TXNS')='Y'