APPS.WIP_VALIDATEMLHEADER_PVT dependencies on DUAL

Line 800: select wip_schedule_groups_s.nextval into l_schedGroupID from dual;

796: and wjsi.delivery_id is not null;
797:
798: if ( l_interfaceTbl.count > 0 ) then
799: for i in 1 .. l_interfaceTbl.count loop
800: select wip_schedule_groups_s.nextval into l_schedGroupID from dual;
801: insert into wip_schedule_groups(
802: schedule_group_id,
803: schedule_group_name,
804: organization_id,

Line 3742: from dual

3738: OR ( ccwac.cost_group_id = mp.default_cost_group_id )));
3739:
3740: else
3741: select 1 into l_dummy
3742: from dual
3743: where exists(select 1
3744: from cst_cg_wip_acct_classes_v ccwac,
3745: mtl_parameters mp
3746: where ccwac.class_code = wjsi_row.class_code

Line 3758: from dual

3754: and mpp.project_id = wjsi_row.project_id)));
3755: end if;
3756: elsif ( wjsi_row.load_type = wip_constants.create_ns_job ) then
3757: select 1 into l_dummy
3758: from dual
3759: where exists(select 1
3760: from wip_non_standard_classes_val_v
3761: where class_code = wjsi_row.class_code
3762: and organization_id = wjsi_row.organization_id);