APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 39: select actual_completion_date from fnd_concurrent_requests req,

35: l_from_date := to_date('01/01/1900 01:00:00','mm/dd/yyyy hh24:mi:ss');
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;