Check if this query helps you

 SELECT VW.pzInsKey as "pzInsKey", VW.pxInsId as "pxInsId", VW.pyRuleName as "pyRuleName", VW.pyClassName as "pyClassName", VW.pxInsName as "pxInsName", VW.pyCircumstanceDate as "pyCircumstanceDate", VW.pyCircumstanceDateProp as "pyCircumstanceDateProp", VW.pyCircumstanceProp as "pyCircumstanceProp", VW.pyCircumstanceVal as "pyCircumstanceVal", VW.pyRuleStarts as "pyRuleStarts", VW.pyRuleEnds as "pyRuleEnds", VW.pyRuleAvailable as "pyRuleAvailable", VW.pyLabel as "pyLabel", VW.pyRuleSet as "pyRuleSet", VW.pyRuleSetVersion as "pyRuleSetVersion", VW.pyClass as "pxObjClass", VW.pxInsName as "pxInsName", IR.pxRuleClassName as "pxRuleClassName" FROM rulesuser.pr_index_reference IR INNER JOIN rulesuser.pr4_rule_vw VW ON IR.pxInsIndexedKey=VW.pzInskey WHERE IR.pxIndexPurpose = 'RuleReference' AND IR.pxObjClass = 'Index-Reference' AND IR.pxRuleFamilyName=? AND IR.pxRuleObjClass=? ORDER BY VW.pyRuleName ASC 

pxRuleFamilyName should be the current activity name and pxRuleObjClass=’Rule-Obj-Activity’

Thanks,

Arun

Hi Arun,

Thanks for replying.

I will be using this frequently in my application if i use the query it may hit the performance is there any other way to get the current activity name.

As the calling activity would be the reference activity for the called activity and  references are stored in pr_index_reference table ,so I think  only way you can get the calling activity name is through this table .

Thanks,

Arun