DBA Data[Home] [Help]

APPS.FV_PO_VALIDATE_GRP dependencies on DUAL

Line 225: into l_agreement_number from dual;

221: 12, x_attribute12,
222: 13, x_attribute13,
223: 14, x_attribute14,
224: 15, x_attribute15 )
225: into l_agreement_number from dual;
226:
227:
228: -- start_date
229: select decode( substr(l_start_date_col,10,2),

Line 245: into l_start_dt from dual;

241: 12, x_attribute12,
242: 13, x_attribute13,
243: 14, x_attribute14,
244: 15, x_attribute15 )
245: into l_start_dt from dual;
246:
247:
248: -- endt_date
249: select decode( substr(l_end_date_col,10,2),

Line 265: into l_end_dt from dual;

261: 12, x_attribute12,
262: 13, x_attribute13,
263: 14, x_attribute14,
264: 15, x_attribute15 )
265: into l_end_dt from dual;
266:
267: l_end_date := trunc(to_date(l_end_dt,'YYYY/MM/DD hh24:mi:ss'));
268:
269: IF l_agreement_number is null THEN