APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on DUAL

Line 468: from dual

464: AND NVL(purchasing_enabled_flag, 'N') = 'Y';
465:
466: cursor pi is
467: select 'OKE_DTS_EXP_PROJECT_INVALID'
468: from dual
469: where not exists (
470: select 'Project is valid'
471: from pa_projects_expend_v
472: where project_id = l_project_id )

Line 475: from dual

471: from pa_projects_expend_v
472: where project_id = l_project_id )
473: union all
474: select 'OKE_PROJECT_NOT_SETUP'
475: from dual
476: where not exists (
477: select 'Project valid for PJM'
478: from pjm_project_parameters
479: where organization_id = l_org_id

Line 483: from dual

479: where organization_id = l_org_id
480: and project_id = l_project_id )
481: /* union all
482: select 'OKE_DTS_EXP_TASK_INVALID'
483: from dual
484: where not exists (
485: select 'Task valid and chargeable'
486: from pa_tasks_expend_v t
487: where project_id = l_project_id

Line 492: from dual

488: and task_id = l_task_id
489: and chargeable_flag = 'Y' ) */
490: union all
491: select 'OKE_TASK_REQUIRED'
492: from dual
493: where not exists (
494: select 'Task Reference OK'
495: from pjm_org_parameters
496: where organization_id = l_org_id

Line 503: from dual

499: );
500:
501: cursor pe is
502: select 'OKE_DTS_EXP_PROJECT_INVALID'
503: from dual
504: where not exists (
505: select 'Project is valid'
506: from pa_projects_expend_v
507: where project_id = l_project_id )

Line 510: from dual

506: from pa_projects_expend_v
507: where project_id = l_project_id )
508: union all
509: select 'OKE_DTS_EXP_TASK_INVALID'
510: from dual
511: where not exists (
512: select 'Task is valid and chargeable'
513: from pa_tasks_expend_v
514: where project_id = l_project_id

Line 519: from dual

515: and task_id = l_task_id
516: and chargeable_flag = 'Y' )
517: union all
518: select 'OKE_DTS_EXP_DATE_INVALID'
519: from dual
520: where not exists (
521: select 'Date is valid for task'
522: from pa_tasks t
523: , pa_projects_all p

Line 532: from dual

528: between nvl(t.start_date , nvl(p.start_date , p_expenditure_item_date - 1))
529: and nvl(t.completion_date , nvl(p.completion_date , p_expenditure_item_date + 1)) )
530: union all
531: select 'OKE_DTS_EXP_TYPE_INVALID'
532: from dual
533: where not exists (
534: select 'Expenditure Type exists and is valid'
535: from pa_expenditure_types_expend_v
536: where expenditure_type = p_expenditure_type_code

Line 540: from dual

536: where expenditure_type = p_expenditure_type_code
537: and system_linkage_function = 'VI' )
538: union all
539: select 'OKE_DTS_EXP_ORG_INVALID'
540: from dual
541: where not exists (
542: select 'Expenditure Org exists and is valid'
543: from pa_organizations_expend_v
544: where organization_id = p_expenditure_organization_id );