DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on DUAL

Line 240: from sys.dual ;

236: end if;
237:
238: IF p_group_id IS NULL THEN
239: select wip_indicators_temp_s.nextval into x_group_id
240: from sys.dual ;
241: ELSE
242: x_group_id := p_group_id ;
243: END IF;
244:

Line 757: from sys.dual ;

753:
754:
755: IF p_group_id IS NULL THEN
756: select wip_indicators_temp_s.nextval into x_group_id
757: from sys.dual ;
758: ELSE
759: x_group_id := p_group_id ;
760: END IF;
761:

Line 978: from sys.dual ;

974: end if;
975:
976: IF p_group_id IS NULL THEN
977: select wip_indicators_temp_s.nextval into x_group_id
978: from sys.dual ;
979: ELSE
980: x_group_id := p_group_id ;
981: END IF;
982:

Line 1492: from sys.dual ;

1488:
1489:
1490: IF p_group_id IS NULL THEN
1491: select wip_indicators_temp_s.nextval into x_group_id
1492: from sys.dual ;
1493: ELSE
1494: x_group_id := p_group_id ;
1495: END IF;
1496:

Line 4157: from sys.dual ;

4153:
4154:
4155: IF p_group_id IS NULL THEN
4156: select wip_indicators_temp_s.nextval into x_group_id
4157: from sys.dual ;
4158: ELSE
4159: x_group_id := p_group_id ;
4160: END IF;
4161:

Line 4189: from dual ;

4185: begin
4186:
4187: select trunc(sysdate)
4188: into g_date_from
4189: from dual ;
4190: end ;
4191:
4192: ELSE
4193: g_date_from := p_date_from;

Line 4625: from sys.dual ;

4621:
4622:
4623: IF p_group_id IS NULL THEN
4624: select wip_indicators_temp_s.nextval into x_group_id
4625: from sys.dual ;
4626: ELSE
4627:
4628: x_group_id := p_group_id ;
4629: END IF;

Line 4658: from dual ;

4654: begin
4655:
4656: select trunc(sysdate)
4657: into g_date_from
4658: from dual ;
4659: end ;
4660:
4661: ELSE
4662: g_date_from := p_date_from;