APPS.FUN_SEQ_BATCH dependencies on FND_CONCURRENT_REQUESTS

Line 1131: select distinct phase_code into l_phase_code from fnd_concurrent_requests

1127: begin
1128: --
1129: -- check if this is the parent request and all child request are completed.
1130: --
1131: select distinct phase_code into l_phase_code from fnd_concurrent_requests
1132: where parent_request_id= p_request_id;
1133: -- all childs completed
1134: if l_phase_code ='C' then
1135: delete from fun_seq_requests where request_id=p_request_id;