APPS.FND_APD dependencies on V$INSTANCE

Line 71: fnd_concurrent_programs fcp, v$instance

67: version
68: into module_id, flow_id, vduration, phase_code , status_code,
69: sdate, cdate, tracefile , vdbname, parentreqid, vversion
70: from fnd_concurrent_requests fcr, fnd_application fa,
71: fnd_concurrent_programs fcp, v$instance
72: where fcr.request_id = p_req_id
73: and fcr.program_application_id = fa.application_id
74: and fcr.concurrent_program_id = fcp.concurrent_program_id
75: and fcr.program_application_id = fcp.application_id;

Line 167: fnd_concurrent_programs fcp, v$instance

163: || '_' || p_req_id || '.trc' , instance_name, parent_request_id,
164: version
165: into module_id, flow_id, tracefile , vdbname, parentreqid, vversion
166: from fnd_concurrent_requests fcr, fnd_application fa,
167: fnd_concurrent_programs fcp, v$instance
168: where fcr.request_id = p_req_id
169: and fcr.program_application_id = fa.application_id
170: and fcr.concurrent_program_id = fcp.concurrent_program_id
171: and fcr.program_application_id = fcp.application_id;

Line 255: fnd_concurrent_programs fcp, v$instance

251: || '_' || p_req_id || '.trc' , instance_name, parent_request_id,
252: version
253: into module_id,flow_id,vduration,tracefile,vdbname,parentreqid,vversion
254: from fnd_concurrent_requests fcr, fnd_application fa,
255: fnd_concurrent_programs fcp, v$instance
256: where fcr.request_id = p_req_id
257: and fcr.program_application_id = fa.application_id
258: and fcr.concurrent_program_id = fcp.concurrent_program_id;
259: EXCEPTION

Line 339: from v$instance i;

335: END;
336: BEGIN
337: select instance_name
338: into vinstance
339: from v$instance i;
340: EXCEPTION
341: when no_data_found then
342: raise_application_error(-20100,'Error select Instance ...');
343: when others then