DBA Data[Home] [Help]

APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 40: FND_CONCURRENT_PROGRAMS prg where req.concurrent_program_id = prg.concurrent_program_id

36: l_to_date := to_date(p_to_date,'yyyy/mm/dd hh24:mi:ss');
37: ELSE
38: select actual_completion_date INTO l_from_date from (
39: select actual_completion_date from fnd_concurrent_requests req,
40: FND_CONCURRENT_PROGRAMS prg where req.concurrent_program_id = prg.concurrent_program_id
41: and prg.concurrent_program_name = 'POSSUPPUBJOB' and actual_completion_date is not null
42: order by actual_completion_date desc) where rownum=1;
43: l_to_date := SYSDATE;
44: fnd_file.put_line(fnd_file.log,'FROM Date is taken from the Last Run Date of the Concurrent Program');