DBA Data[Home] [Help]

APPS.CSTPOMLD dependencies on DUAL

Line 116: from dual;

112: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
113: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
114: into l_from_date,
115: l_to_date
116: from dual;
117:
118: elsif (i_from_date is NULL) then
119: if (i_load_option = 1) then
120: l_from_date := to_date('1900/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');

Line 169: FROM sys.dual;

165:
166: if l_first_build = 1 THEN
167: SELECT cst_margin_build_s.nextval
168: INTO l_build_id
169: FROM sys.dual;
170:
171: l_build_name := to_char(l_build_id);
172: l_build_descr := l_le_name;
173: END IF;

Line 233: sys.dual;

229: l_program_appl_id,
230: l_program_id,
231: SYSDATE
232: FROM
233: sys.dual;
234:
235: else
236:
237: UPDATE CST_BIS_MARGIN_BUILD