APPS.PAY_RESTRICT_VAL_PKG SQL Statements

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

Line: 14

 SELECT 1
 FROM   PAY_RESTRICTION_VALUES PRV
 WHERE  PRV.VALUE                     = P_VALUE
 AND    PRV.CUSTOMIZED_RESTRICTION_ID = P_CUSTOMIZED_RESTRICTION_ID
 AND    PRV.RESTRICTION_CODE          = P_RESTRICTION_CODE
 AND   (PRV.ROWID                   <> P_ROWID
                                     OR P_ROWID IS NULL);

Line: 22

SELECT 1
FROM   PAY_RESTRICTION_PARAMETERS PRP
WHERE  PRP.APPLICATION_ID             =  P_APPLICATION_ID
AND    PRP.FORM_NAME                  =  P_FORM_NAME
AND    PRP.RESTRICTION_CODE           =  P_RESTRICTION_CODE
AND    PRP.MULTIPLE_RESTRICTIONS_FLAG = 'N'
AND    EXISTS
       (SELECT 1
        FROM   PAY_RESTRICTION_VALUES PRV
        WHERE  PRV.CUSTOMIZED_RESTRICTION_ID = P_CUSTOMIZED_RESTRICTION_ID2
        AND    PRV.RESTRICTION_CODE          = PRP.RESTRICTION_CODE
        AND   (PRV.ROWID                    <> P_ROWID
        OR     P_ROWID IS NULL));

Line: 67

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_RESTRICTION_CODE
 AND    HR.LOOKUP_TYPE = 'FORM_RESTRICTION_TYPE';

Line: 73

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'ACTION_TYPE';

Line: 79

 SELECT PES.ELEMENT_SET_NAME
 FROM   PAY_ELEMENT_SETS PES
 WHERE  PES.ELEMENT_SET_ID =  P_VALUE;

Line: 84

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'PROCESSING_TYPE';

Line: 90

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'EMP_APL';

Line: 96

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'ENTRY_TYPE';

Line: 102

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'ASG_SET';

Line: 108

 SELECT REPS.QP_REPORT_NAME
 FROM   FF_QP_REPORTS REPS,
        FF_FORMULA_TYPES TYPES
 WHERE  REPS.FORMULA_TYPE_ID  = TYPES.FORMULA_TYPE_ID
 AND    REPS.QP_REPORT_ID     = P_VALUE;

Line: 115

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'ORG_CLASS';

Line: 121

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE ='PER_FUNCTION';

Line: 127

 SELECT F.ID_FLEX_STRUCTURE_NAME
 FROM   FND_ID_FLEX_STRUCTURES_VL F,
        PER_SPECIAL_INFO_TYPES S
 WHERE  S.SPECIAL_INFORMATION_TYPE_ID = P_VALUE
 AND    S.BUSINESS_GROUP_ID           = P_BUSINESS_GROUP_ID
 AND    F.ID_FLEX_NUM                 = S.ID_FLEX_NUM
 AND    F.ID_FLEX_CODE                = 'PEA';

Line: 136

 SELECT PUT.USER_TABLE_NAME
 FROM   PAY_USER_TABLES PUT
 WHERE  PUT.USER_TABLE_ID  = P_VALUE;

Line: 141

 SELECT PPTTL.USER_PERSON_TYPE
 FROM   PER_PERSON_TYPES_TL PPTTL,
        PER_PERSON_TYPES PPT
 WHERE  PPT.PERSON_TYPE_ID = P_VALUE
 AND    PPT.PERSON_TYPE_ID = PPTTL.PERSON_TYPE_ID
 AND    PPTTL.LANGUAGE     = userenv('LANG');

Line: 149

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE ='HR_PTU_ACTION_TYPES';

Line: 157

 SELECT DESCRIPTION
 FROM   PER_ASSIGNMENT_INFO_TYPES_V
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 162

 SELECT DESCRIPTION
 FROM   PER_CONTACT_INFO_TYPES_VL
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 167

 SELECT nvl(DESCRIPTION,INFORMATION_TYPE)
 FROM   PER_PEOPLE_INFO_TYPES
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 172

 SELECT DESCRIPTION
 FROM   PER_POSITION_INFO_TYPES
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 177

 SELECT DESCRIPTION
 FROM   PER_JOB_INFO_TYPES
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 182

 SELECT DESCRIPTION
 FROM   HR_LOCATION_INFO_TYPES
 WHERE  INFORMATION_TYPE = P_VALUE;

Line: 187

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'PER_ADV_FIND_ITEMS';

Line: 193

 SELECT DISPLAY_NAME
 FROM   WF_MESSAGES_TL WMTL
 WHERE  TYPE     IN ('PEQHNOT','PECWKNOT') --Bug# 3057859
 AND    LANGUAGE = userenv('LANG')
 AND    NAME     = P_VALUE;

Line: 200

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'PER_QH_ACTION';

Line: 206

 SELECT HR.MEANING
 FROM   HR_LOOKUPS HR
 WHERE  HR.LOOKUP_CODE = P_VALUE
 AND    HR.LOOKUP_TYPE = 'PER_QH_NEW';

Line: 344

  SELECT PES.ELEMENT_SET_NAME
  ,      PES.LEGISLATION_CODE
  FROM   PAY_ELEMENT_SETS   PES
  WHERE  PES.ELEMENT_SET_ID = P_VALUE;

Line: 350

  SELECT PUT.USER_TABLE_NAME
  ,      PUT.LEGISLATION_CODE
  FROM   PAY_USER_TABLES    PUT
  WHERE  PUT.USER_TABLE_ID  = P_VALUE;

Line: 356

  SELECT REPS.QP_REPORT_NAME
  ,      REPS.LEGISLATION_CODE
  FROM   FF_QP_REPORTS      REPS
  ,      FF_FORMULA_TYPES  TYPES
  WHERE  REPS.FORMULA_TYPE_ID  = TYPES.FORMULA_TYPE_ID
  AND    REPS.QP_REPORT_ID     = P_VALUE;

Line: 364

  SELECT F.ID_FLEX_STRUCTURE_NAME
  FROM   FND_ID_FLEX_STRUCTURES_VL F
  ,      PER_SPECIAL_INFO_TYPES    S
  WHERE  S.SPECIAL_INFORMATION_TYPE_ID = P_VALUE
  AND    S.BUSINESS_GROUP_ID           IS NULL
  AND    F.ID_FLEX_NUM                 = S.ID_FLEX_NUM
  AND    F.ID_FLEX_CODE                = 'PEA';

Line: 373

  SELECT PPT.USER_PERSON_TYPE
  FROM   PER_PERSON_TYPES PPT
  WHERE  PPT.PERSON_TYPE_ID = P_VALUE;

Line: 423

  SELECT PES.ELEMENT_SET_ID
  FROM   PAY_ELEMENT_SETS     PES
  WHERE  PES.ELEMENT_SET_NAME = P_VALUE
  AND    (P_LEG_CODE          IS NULL
  OR     (P_LEG_CODE          IS NOT NULL
  AND    PES.LEGISLATION_CODE = P_LEG_CODE));

Line: 431

  SELECT PUT.USER_TABLE_ID
  FROM   PAY_USER_TABLES      PUT
  WHERE  PUT.USER_TABLE_NAME  = P_VALUE
  AND    (P_LEG_CODE          IS NULL
  OR     (P_LEG_CODE          IS NOT NULL
  AND    PUT.LEGISLATION_CODE = P_LEG_CODE));

Line: 439

  SELECT REPS.QP_REPORT_ID
  FROM   FF_QP_REPORTS         REPS
  ,      FF_FORMULA_TYPES      TYPES
  WHERE  REPS.FORMULA_TYPE_ID  = TYPES.FORMULA_TYPE_ID
  AND    REPS.QP_REPORT_NAME   = P_VALUE
  AND    (P_LEG_CODE           IS NULL
  OR     (P_LEG_CODE           IS NOT NULL
  AND    REPS.LEGISLATION_CODE = P_LEG_CODE));

Line: 449

  SELECT S.SPECIAL_INFORMATION_TYPE_ID
  FROM   FND_ID_FLEX_STRUCTURES_VL F
  ,      PER_SPECIAL_INFO_TYPES    S
  WHERE  F.ID_FLEX_STRUCTURE_NAME = P_VALUE
  AND    F.ID_FLEX_CODE           = 'PEA'
  AND    F.ID_FLEX_NUM            = S.ID_FLEX_NUM
  AND    S.BUSINESS_GROUP_ID      IS NULL;

Line: 458

  SELECT PPT.PERSON_TYPE_ID
  FROM   PER_PERSON_TYPES PPT
  WHERE  PPT.USER_PERSON_TYPE = P_VALUE
  AND    PPT.BUSINESS_GROUP_ID IS NULL;