APPS.CTO_OSS_SOURCE_PK dependencies on DUAL

Line 403: from dual

399: l_stmt_num := 30;
400: Begin
401: select 'Y'
402: into l_oss_defined
403: from dual
404: where exists (select 'x'
405: from bom_cto_oss_components);
406: Exception when no_data_found then
407: l_oss_defined := 'N';

Line 3004: from dual;

3000: l_sourcing_rule_rec.status := 1;
3001: l_sourcing_rule_rec.planning_active := 1;
3002: select 'CTO*'||bom_cto_oss_source_rule_s1.nextval
3003: into l_sourcing_rule_rec.sourcing_rule_name
3004: from dual;
3005:
3006: l_sourcing_rule_rec.Sourcing_rule_type := 1;
3007:
3008: /*

Line 3011: from dual;

3007:
3008: /*
3009: select mrp_sourcing_rules_s.nextval
3010: into l_sourcing_rule_rec.sourcing_rule_id
3011: from dual;
3012: */
3013:
3014: l_sourcing_rule_rec.operation := MRP_Globals.G_OPR_CREATE;
3015:

Line 4078: from dual

4074: l_check_flag varchar2(1);
4075: Begin
4076: Select 'X'
4077: into l_check_flag
4078: from dual
4079: where exists (select 'x' from bom_cto_oss_components);
4080:
4081: If l_check_flag = 'X' then
4082: If PG_DEBUG <> 0 Then