APPS.BOMPNORD dependencies on DUAL

Line 111: FROM sys.dual;

107: AND alternate_bom_designator is null;
108:
109: Cursor Convert_Date is
110: SELECT to_date(nvl(REV_DATE, SYSDATE),'YYYY/MM/DD HH24:MI') rev_datetime
111: FROM sys.dual;
112:
113: Cursor Check_Flag is
114: Select 1
115: FROM bom_explosions be

Line 141: FROM sys.dual;

137: Pragma exception_init(X_Row_locked, -54);
138:
139: Cursor Get_New_Group is
140: SELECT bom_config_explosions_s.nextval group_id
141: FROM sys.dual;
142:
143: Begin
144:
145: error_code := 0;

Line 163: FROM sys.dual;

159: If rev_date is NOT NULL then
160: stmt_num := 10;
161: SELECT to_date(REV_DATE,'YYYY/MM/DD HH24:MI')
162: into x_revision_date
163: FROM sys.dual;
164: else
165: stmt_num := 20;
166: SELECT to_date(to_char(sysdate,'YYYY/MM/DD HH24:MI'),'YYYY/MM/DD HH24:MI')
167: into x_revision_date

Line 168: FROM sys.dual;

164: else
165: stmt_num := 20;
166: SELECT to_date(to_char(sysdate,'YYYY/MM/DD HH24:MI'),'YYYY/MM/DD HH24:MI')
167: into x_revision_date
168: FROM sys.dual;
169: end if;
170:
171: -- Bug 4252245 ends
172: