DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on PA_TASKS

Line 1112: from pa_tasks_expend_v t

1108: select 'OKE_DTS_EXP_TASK_INVALID'
1109: from dual
1110: where not exists (
1111: select 'Task valid and chargeable'
1112: from pa_tasks_expend_v t
1113: where project_id = l_project_id
1114: and task_id = l_task_id
1115: and chargeable_flag = 'Y' )
1116: union all

Line 1142: from pa_tasks_expend_v

1138: select 'OKE_DTS_EXP_TASK_INVALID'
1139: from dual
1140: where not exists (
1141: select 'Task is valid and chargeable'
1142: from pa_tasks_expend_v
1143: where project_id = l_project_id
1144: and task_id = l_task_id
1145: and chargeable_flag = 'Y' )
1146: union all

Line 1151: from pa_tasks t

1147: select 'OKE_DTS_EXP_DATE_INVALID'
1148: from dual
1149: where not exists (
1150: select 'Date is valid for task'
1151: from pa_tasks t
1152: , pa_projects_all p
1153: where t.project_id = l_project_id
1154: and t.task_id = l_task_id
1155: and p.project_id = t.project_id