DBA Data[Home] [Help]

APPS.FA_CHK_BOOKSTS_PKG dependencies on V$SESSION

Line 993: from v$session a

989: -- even if request was cancelled/terminated,
990: -- make sure the db processes no longer exist
991: select count(*)
992: into h_count
993: from v$session a
994: where a.audsid in
995: (select ORACLE_SESSION_ID
996: from fnd_concurrent_requests
997: where request_id = h_mass_req_id

Line 1073: from v$session a

1069: -- even if request was cancelled/terminated,
1070: -- make sure the db processes no longer exist
1071: select count(*)
1072: into h_count
1073: from v$session a
1074: where a.audsid in
1075: (select ORACLE_SESSION_ID
1076: from fnd_concurrent_requests
1077: where request_id = h_ca_req_id