APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 73: select count(1) into l_rolequery_result from JTF_RS_ROLES_B ROLEB , JTF_RS_ROLE_RELATIONS ROLER

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:
73: select count(1) into l_rolequery_result from JTF_RS_ROLES_B ROLEB , JTF_RS_ROLE_RELATIONS ROLER
74: WHERE ROLER.DELETE_FLAG ='N' AND nvl(ROLER.END_DATE_ACTIVE,TO_DATE('01/01/9999','DD/MM/RRRR')) >= SYSDATE
75: AND ROLER.ROLE_ID= ROLEB.ROLE_ID AND ROLEB.ROLE_TYPE_CODE='SALES_COMP_PAYMENT_ANALIST'
76: AND ROLER.ROLE_RESOURCE_ID = l_resource_id;
77: