APPS.PAY_FLOW_REQUESTS_PKG dependencies on FND_CONCURRENT_REQUESTS

Line 483: from fnd_concurrent_requests

479:
480: BEGIN
481: --
482: select status_code into l_process_status
483: from fnd_concurrent_requests
484: where request_id = l_request_id;
485:
486: -- If any of the child process has errored, abort the flow
487: if l_process_status = 'E' then

Line 605: fnd_concurrent_requests fcr

601: -- Cursor to get the parent fnd requests which have completed processing
602: CURSOR get_parent_fnd_requests is
603: select ppr.fnd_request_id
604: from PAY_PROCESS_REQUESTS ppr,
605: fnd_concurrent_requests fcr
606: where ppr.fnd_request_id is not null
607: and ppr.PARENT_FND_REQUEST_ID is null
608: and ppr.fnd_request_id = fcr.request_id
609: and fcr.phase_code = 'C'

Line 618: fnd_concurrent_requests fcr

614: CURSOR get_child_requests(p_fnd_request_id pay_process_requests.fnd_request_id%TYPE) IS
615: select ppr_child.fnd_request_id
616: from PAY_PROCESS_REQUESTS ppr_child,
617: pay_process_requests ppr_parent,
618: fnd_concurrent_requests fcr
619: where ppr_child.parent_fnd_request_id = p_fnd_request_id
620: and ppr_parent.fnd_request_id = ppr_child.parent_fnd_request_id
621: and ppr_parent.fnd_request_id = fcr.request_id
622: and fcr.phase_code = 'C'

Line 778: fnd_concurrent_requests fcr

774: -- and the child request is running, the flow cannot be cancelled
775: CURSOR get_pending_child_request(p_fnd_request_id number) IS
776: select ppr.fnd_request_id
777: from pay_process_requests ppr,
778: fnd_concurrent_requests fcr
779: where ppr.fnd_request_id =
780: ( select min(fnd_request_id)
781: from pay_process_requests
782: where parent_fnd_request_id = p_fnd_request_id