DBA Data[Home] [Help]

APPS.FND_DIAG_CM dependencies on FND_CONCURRENT_REQUESTS

Line 59: from fnd_concurrent_requests a, fnd_concurrent_requests b

55: NUMDOM IN NUMBER DEFAULT 10)
56: is
57: CURSOR con_cursor(parrqid NUMBER, apid NUMBER, bpid NUMBER, cpid NUMBER) IS
58: select a.request_id rqa, b.request_id rqb
59: from fnd_concurrent_requests a, fnd_concurrent_requests b
60: where a.PARENT_REQUEST_ID = parrqid
61: and b.PARENT_REQUEST_ID = parrqid
62: and (a.CRM_RELEASE_DATE < b.actual_COMPLETION_DATE and
63: a.actual_completion_date > b.actual_start_date)