2002: IS
2003: CURSOR c_from_same_group(b_owner NUMBER,b_member NUMBER)
2004: IS
2005: SELECT 1
2006: FROM JTF_RS_GROUP_MEMBERS memG
2007: WHERE RESOURCE_ID = b_member
2008: AND EXISTS (SELECT 1 FROM JTF_RS_GROUP_MEMBERS ownG
2009: WHERE ownG.GROUP_ID=memG.GROUP_ID
2010: AND ownG.RESOURCE_ID=b_owner);
2004: IS
2005: SELECT 1
2006: FROM JTF_RS_GROUP_MEMBERS memG
2007: WHERE RESOURCE_ID = b_member
2008: AND EXISTS (SELECT 1 FROM JTF_RS_GROUP_MEMBERS ownG
2009: WHERE ownG.GROUP_ID=memG.GROUP_ID
2010: AND ownG.RESOURCE_ID=b_owner);
2011:
2012: l_temp NUMBER :=0;