DBA Data[Home] [Help]

APPS.FND_WF_STANDARD dependencies on FND_CONCURRENT_REQUESTS

Line 102: from fnd_concurrent_requests fr1, fnd_concurrent_requests fr2

98: complete_status varchar2(10):=null;
99:
100: cursor avgCPtime(c_reqID in number) is
101: select avg(fr1.actual_completion_date - fr1.actual_start_date)
102: from fnd_concurrent_requests fr1, fnd_concurrent_requests fr2
103: where fr2.request_id = c_reqID
104: and fr1.concurrent_program_id = fr2.concurrent_program_id
105: and fr1.program_application_id = fr2.program_application_id
106: and fr1.actual_start_date is not null