DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PA_TASKS_EXPEND_V

Line 3504: from pa_tasks_expend_v pa,

3500: begin
3501: if ( wjsi_row.load_type = wip_constants.resched_job ) then
3502: select pa.task_id
3503: into wjsi_row.task_id
3504: from pa_tasks_expend_v pa,
3505: wip_discrete_jobs wdj
3506: where wdj.wip_entity_id = wjsi_row.wip_entity_id
3507: and pa.project_id = nvl(wjsi_row.project_id, wdj.project_id)
3508: and pa.task_number = wjsi_row.task_number;

Line 3512: from pa_tasks_expend_v

3508: and pa.task_number = wjsi_row.task_number;
3509: else
3510: select task_id
3511: into wjsi_row.task_id
3512: from pa_tasks_expend_v
3513: where project_id = wjsi_row.project_id
3514: and task_number = wjsi_row.task_number;
3515: end if;
3516: exception