DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PA_TASKS_EXPEND_V

Line 3585: from pa_tasks_expend_v pa,

3581: begin
3582: if ( wjsi_row.load_type = wip_constants.resched_job ) then
3583: select pa.task_id
3584: into wjsi_row.task_id
3585: from pa_tasks_expend_v pa,
3586: wip_discrete_jobs wdj
3587: where wdj.wip_entity_id = wjsi_row.wip_entity_id
3588: and pa.project_id = nvl(wjsi_row.project_id, wdj.project_id)
3589: and pa.task_number = wjsi_row.task_number;

Line 3593: from pa_tasks_expend_v

3589: and pa.task_number = wjsi_row.task_number;
3590: else
3591: select task_id
3592: into wjsi_row.task_id
3593: from pa_tasks_expend_v
3594: where project_id = wjsi_row.project_id
3595: and task_number = wjsi_row.task_number;
3596: end if;
3597: exception