APPS.BIL_TX_RES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

	SELECT 'Y'
 	INTO l_manager
        FROM JTF_RS_GROUP_MBR_ROLE_VL
        WHERE resource_id = l_resource_id
        AND group_id = l_group_id
        AND (admin_flag = 'Y' OR
             manager_flag='Y')
        AND rownum < 2;

Line: 54

	SELECT 'x'
	INTO l_dummy
        FROM  JTF_RS_GROUP_MBR_ROLE_VL
        WHERE resource_id = l_resource_id
        AND group_id = l_group_id
        AND (admin_flag = 'Y' OR
            	manager_flag='Y')
       	AND  rownum < 2;