DBA Data[Home] [Help]

APPS.OKE_AMG_GRP dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 355: Select 'x' from pa_organizations_expend_v o

351: and et.project_id is null
352: and expenditure_type = p_expenditure_type;
353:
354: Cursor c_check_expend_org IS
355: Select 'x' from pa_organizations_expend_v o
356: where active_flag = 'Y'
357: and trunc(sysdate) between o.date_from and nvl(o.date_to, trunc(sysdate))
358: and organization_id= p_expenditure_org_id;
359: