APPS.CSM_UTIL_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 2057: FROM JTF_RS_GROUP_MEMBERS memG

2053: IS
2054: CURSOR c_from_same_group(b_owner NUMBER,b_member NUMBER)
2055: IS
2056: SELECT 1
2057: FROM JTF_RS_GROUP_MEMBERS memG
2058: WHERE RESOURCE_ID = b_member
2059: AND EXISTS (SELECT 1 FROM JTF_RS_GROUP_MEMBERS ownG
2060: WHERE ownG.GROUP_ID=memG.GROUP_ID
2061: AND ownG.RESOURCE_ID=b_owner);

Line 2059: AND EXISTS (SELECT 1 FROM JTF_RS_GROUP_MEMBERS ownG

2055: IS
2056: SELECT 1
2057: FROM JTF_RS_GROUP_MEMBERS memG
2058: WHERE RESOURCE_ID = b_member
2059: AND EXISTS (SELECT 1 FROM JTF_RS_GROUP_MEMBERS ownG
2060: WHERE ownG.GROUP_ID=memG.GROUP_ID
2061: AND ownG.RESOURCE_ID=b_owner);
2062:
2063: l_temp NUMBER :=0;