DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_CONC_PP_ACTIONS

Line 766: from fnd_conc_pp_actions pp,

762: function get_notifications(request_id in number) return varchar2 is
763:
764: cursor notifications(req_id number) is
765: select substrb(display_name,1,80) dname
766: from fnd_conc_pp_actions pp,
767: wf_roles wf
768: where pp.concurrent_request_id = req_id
769: and pp.action_type = 2
770: and wf.orig_system_id = pp.orig_system_id

Line 825: fnd_conc_pp_actions A,

821: decode(nvl(A.Action_type,0), 6, O.file_name, R.outfile_name),
822: decode(nvl(A.action_type,0), 6, O.file_size, R.ofile_size),
823: R.save_output_flag
824: from fnd_concurrent_requests R,
825: fnd_conc_pp_actions A,
826: fnd_conc_req_outputs O
827: where R.request_id = A.concurrent_request_id (+)
828: and R.request_id = O.concurrent_request_id (+)
829: and R.request_id = req_id