APPS.CSTPMRGL dependencies on DUAL

Line 130: from dual;

126: select NVL(fnd_date.canonical_to_date(i_from_date),to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')),
127: NVL(fnd_date.canonical_to_date(i_to_date), SYSDATE)
128: into l_from_date,
129: l_to_date
130: from dual;
131:
132: elsif (i_from_date is NULL) then
133: if (i_load_option = 1) then
134: l_from_date := to_date('1980/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');

Line 144: from dual ;

140: end if;
141:
142: Select trunc(l_from_date) , trunc(l_to_date)+ .99999
143: into l_from_date , l_to_date
144: from dual ;
145:
146: -- DBMS_OUTPUT.PUT_LINE('l_le_name = ' || l_le_name);
147: -- DBMS_OUTPUT.PUT_LINE('l_from_date = ' || to_char(l_from_date));
148: -- DBMS_OUTPUT.PUT_LINE('l_to_date = ' || to_char(l_to_date));

Line 182: FROM sys.dual;

178:
179: if l_first_build = 1 THEN
180: SELECT cst_margin_build_s.nextval
181: INTO l_build_id
182: FROM sys.dual;
183:
184: l_build_name := to_char(l_build_id);
185: l_build_descr := l_le_name;
186: END IF;