APPS.WIP_JSI_DEFAULTER dependencies on PA_TASKS_EXPEND_V

Line 465: from pa_tasks_expend_v pa, wip_discrete_jobs wdj

461: elsif(wjsi_row.task_number is not null and wjsi_row.task_id is null) then
462: if(wjsi_row.load_type = wip_constants.resched_job) then
463: select pa.task_id
464: into wjsi_row.task_id
465: from pa_tasks_expend_v pa, wip_discrete_jobs wdj
466: where wdj.wip_entity_id = wjsi_row.wip_entity_id
467: and pa.project_id = nvl(wjsi_row.project_id, wdj.project_id)
468: and pa.task_number = wjsi_row.task_number;
469: else

Line 472: from pa_tasks_expend_v

468: and pa.task_number = wjsi_row.task_number;
469: else
470: select task_id
471: into wjsi_row.task_id
472: from pa_tasks_expend_v
473: where project_id = wjsi_row.project_id
474: and task_number = wjsi_row.task_number;
475: end if;
476: elsif(wjsi_row.task_number is not null and wjsi_row.task_id is not null) then