DBA Data[Home] [Help]

APPS.FND_CONC_SSWA dependencies on FND_CONC_PP_ACTIONS

Line 827: from fnd_conc_pp_actions pp,

823: function get_notifications(request_id in number) return varchar2 is
824:
825: cursor notifications(req_id number) is
826: select substrb(display_name,1,80) dname
827: from fnd_conc_pp_actions pp,
828: wf_roles wf
829: where pp.concurrent_request_id = req_id
830: and pp.action_type = 2
831: and wf.orig_system_id = pp.orig_system_id

Line 886: fnd_conc_pp_actions A,

882: decode(nvl(A.Action_type,0), 6, O.file_name, R.outfile_name),
883: decode(nvl(A.action_type,0), 6, O.file_size, R.ofile_size),
884: R.save_output_flag
885: from fnd_concurrent_requests R,
886: fnd_conc_pp_actions A,
887: fnd_conc_req_outputs O
888: where R.request_id = A.concurrent_request_id (+)
889: and R.request_id = O.concurrent_request_id (+)
890: and R.request_id = req_id