APPS.WIP_VALIDATEMLHEADER_PVT dependencies on DUAL

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

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

Line 3628: from dual

3624: begin
3625: if ( wjsi_row.load_type = wip_constants.create_job) then
3626: if(wjsi_row.project_id is null) then
3627: select 1 into l_dummy
3628: from dual
3629: where exists(select 1
3630: from cst_cg_wip_acct_classes_v
3631: where class_code = wjsi_row.class_code
3632: and organization_id = wjsi_row.organization_id

Line 3636: from dual

3632: and organization_id = wjsi_row.organization_id
3633: and class_type = wip_constants.discrete);
3634: else
3635: select 1 into l_dummy
3636: from dual
3637: where exists(select 1
3638: from cst_cg_wip_acct_classes_v ccwac,
3639: mtl_parameters mp
3640: where ccwac.class_code = wjsi_row.class_code

Line 3652: from dual

3648: and mpp.project_id = wjsi_row.project_id)));
3649: end if;
3650: elsif ( wjsi_row.load_type = wip_constants.create_ns_job ) then
3651: select 1 into l_dummy
3652: from dual
3653: where exists(select 1
3654: from wip_non_standard_classes_val_v
3655: where class_code = wjsi_row.class_code
3656: and organization_id = wjsi_row.organization_id);