APPS.IGS_AS_NOTIFY_STUDENT SQL Statements

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

Line: 31

          SELECT
	         igs_as_wf_beas006_s.NEXTVAL
          FROM
	        dual;

Line: 80

     l_parameter_list_t.delete;

Line: 113

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id;

Line: 121

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;

Line: 312

          SELECT igs_as_reldate_s.NEXTVAL
          FROM  dual;

Line: 319

        SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 325

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = p_instructor;

Line: 332

        SELECT user_name
	   FROM   fnd_user
	   WHERE  user_id = (SELECT  FND_GLOBAL.USER_ID user_id FROM dual);

Line: 420

     l_parameter_list_t.delete;

Line: 455

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id;

Line: 463

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;