APPS.CTO_OSS_SOURCE_PK dependencies on DUAL

Line 378: from dual

374: l_stmt_num := 30;
375: Begin
376: select 'Y'
377: into l_oss_defined
378: from dual
379: where exists (select 'x'
380: from bom_cto_oss_components);
381: Exception when no_data_found then
382: l_oss_defined := 'N';

Line 2573: from dual;

2569: l_sourcing_rule_rec.status := 1;
2570: l_sourcing_rule_rec.planning_active := 1;
2571: select 'CTO*'||bom_cto_oss_source_rule_s1.nextval
2572: into l_sourcing_rule_rec.sourcing_rule_name
2573: from dual;
2574:
2575: l_sourcing_rule_rec.Sourcing_rule_type := 1;
2576:
2577: /*

Line 2580: from dual;

2576:
2577: /*
2578: select mrp_sourcing_rules_s.nextval
2579: into l_sourcing_rule_rec.sourcing_rule_id
2580: from dual;
2581: */
2582:
2583: l_sourcing_rule_rec.operation := MRP_Globals.G_OPR_CREATE;
2584:

Line 3559: from dual

3555: l_check_flag varchar2(1);
3556: Begin
3557: Select 'X'
3558: into l_check_flag
3559: from dual
3560: where exists (select 'x' from bom_cto_oss_components);
3561:
3562: If l_check_flag = 'X' then
3563: If PG_DEBUG <> 0 Then