APPS.PMI_SECURITY_PKG SQL Statements

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

Line: 12

       SELECT 	Responsibility_id
       FROM   	fnd_user_resp_groups
       WHERE  	User_id = p_user_id
       AND	start_date <= SYSDATE
       AND 	(end_date IS NULL OR
		 end_date >= SYSDATE)
	AND 	responsibility_application_id = 558;

Line: 74

		      SELECT  count(*)
                    INTO l_orgn_cnt
                  FROM sy_orgn_mst a
                  WHERE co_code = l_profile_value
		        AND a.orgn_code = p_orgn_code;

Line: 89

            SELECT  count(*)
              INTO l_orgn_cnt
            FROM  sy_orgn_usr
            WHERE user_id   = l_user_id
              AND orgn_code = p_orgn_code;