DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on V$SESSION

Line 1021: from v$session a

1017: -- even if request was cancelled/terminated,
1018: -- make sure the db processes no longer exist
1019: select count(*)
1020: into h_count
1021: from v$session a
1022: where a.audsid in
1023: (select ORACLE_SESSION_ID
1024: from fnd_concurrent_requests
1025: where request_id = h_mass_req_id

Line 1105: from v$session a

1101: -- even if request was cancelled/terminated,
1102: -- make sure the db processes no longer exist
1103: select count(*)
1104: into h_count
1105: from v$session a
1106: where a.audsid in
1107: (select ORACLE_SESSION_ID
1108: from fnd_concurrent_requests
1109: where request_id = h_ca_req_id