APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on JTF_RS_GROUP_MBR_ROLE_VL

Line 68: SELECT count(1) into l_groupquery_result FROM JTF_RS_GROUP_MBR_ROLE_VL GPM, JTF_RS_GROUP_USAGES GPU

64: CLOSE get_salesrep;
65:
66: select je.resource_id into l_resource_id from jtf_rs_resource_extns je where je.user_id =l_user_id;
67:
68: SELECT count(1) into l_groupquery_result FROM JTF_RS_GROUP_MBR_ROLE_VL GPM, JTF_RS_GROUP_USAGES GPU
69: WHERE GPM.GROUP_ID=GPU.GROUP_ID and GPU.usage='COMP_PAYMENT'
70: AND NVL(GPM.END_DATE_ACTIVE,TO_DATE('01/01/9999','DD/MM/RRRR')) >= SYSDATE
71: AND GPM.RESOURCE_ID = l_resource_id;
72: