APPS.BSC_PMA_DIAG_TEST dependencies on V$SESSION

Line 68: v$aw_olap,all_aws,v$session

64: END;
65: --CHECK IF THERE ARE ANY AW LOCKS
66:
67: SELECT COUNT(1) INTO h_count FROM
68: v$aw_olap,all_aws,v$session
69: WHERE all_aws.aw_name=bsc_aw_management.get_aw_workspace_name
70: AND all_aws.aw_number=v$aw_olap.aw_number
71: AND v$session.sid=v$aw_olap.session_id;
72:

Line 71: AND v$session.sid=v$aw_olap.session_id;

67: SELECT COUNT(1) INTO h_count FROM
68: v$aw_olap,all_aws,v$session
69: WHERE all_aws.aw_name=bsc_aw_management.get_aw_workspace_name
70: AND all_aws.aw_number=v$aw_olap.aw_number
71: AND v$session.sid=v$aw_olap.session_id;
72:
73:
74: IF h_count >0 THEN
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;