DBA Data[Home] [Help]

APPS.OKE_DTS_INTEGRATION_PKG dependencies on PA_TASKS

Line 1150: from pa_tasks_expend_v t

1146: select 'OKE_DTS_EXP_TASK_INVALID'
1147: from dual
1148: where not exists (
1149: select 'Task valid and chargeable'
1150: from pa_tasks_expend_v t
1151: where project_id = l_project_id
1152: and task_id = l_task_id
1153: and chargeable_flag = 'Y' ) */
1154: union all

Line 1180: from pa_tasks_expend_v

1176: select 'OKE_DTS_EXP_TASK_INVALID'
1177: from dual
1178: where not exists (
1179: select 'Task is valid and chargeable'
1180: from pa_tasks_expend_v
1181: where project_id = l_project_id
1182: and task_id = l_task_id
1183: and chargeable_flag = 'Y' )
1184: union all

Line 1189: from pa_tasks t

1185: select 'OKE_DTS_EXP_DATE_INVALID'
1186: from dual
1187: where not exists (
1188: select 'Date is valid for task'
1189: from pa_tasks t
1190: , pa_projects_all p
1191: where t.project_id = l_project_id
1192: and t.task_id = l_task_id
1193: and p.project_id = t.project_id