APPS.PAY_CUST_RESTRICT_PKG SQL Statements

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

Line: 12

 SELECT 1

 FROM   PAY_CUSTOMIZED_RESTRICTIONS PCR
 WHERE  UPPER(PCR.NAME)    = UPPER(P_NAME)

 AND     nvl(PCR.business_group_id, nvl(P_BUSINESS_GROUP_ID, -9999) )
                  =  nvl(P_BUSINESS_GROUP_ID, -9999)
 AND     nvl(PCR.legislation_code, nvl(P_LEGISLATION_CODE, 'XXX') )
                  =  nvl(P_LEGISLATION_CODE, 'XXX')
 AND    (PCR.ROWID <> P_ROWID OR P_ROWID IS NULL);

Line: 25

 SELECT PAY_CUSTOMIZED_RESTRICTIONS_S.NEXTVAL
 FROM SYS.DUAL;

Line: 37

      RETURN;               /* select from sequence                     */

Line: 48

 SELECT F.USER_FORM_NAME
 FROM   FND_FORM_VL F
 WHERE  F.FORM_NAME       = P_FORM_NAME
 AND    F.APPLICATION_ID  = P_APPLICATION_ID;