APPS.IGS_AS_ATT_WF_PKG SQL Statements

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

Line: 12

PROCEDURE   Select_Approver (
                                                       Itemtype        IN           VARCHAR2,
                                                       Itemkey         IN           VARCHAR2,
                                                       Actid           IN           NUMBER,
                                                       Funcmode        IN           VARCHAR2,
                                                       Resultout       OUT NOCOPY        VARCHAR2
                                                     )
IS



l_api_name         CONSTANT VARCHAR2(30)   := 'Select_Approver' ;

Line: 31

   SELECT INSTRUCTOR_ID
   FROM   IGS_PS_USEC_TCH_RESP
   WHERE  LEAD_INSTRUCTOR_FLAG = 'Y'      AND
          UOO_ID     = lv_uoo_id;

Line: 37

   SELECT user_name
   FROM   FND_USER
   WHERE  person_party_id = lv_instructor_id ;

Line: 44

  SAVEPOINT Select_Approver;

Line: 93

     ROLLBACK TO Select_Approver;

Line: 106

END Select_Approver ;