APPS.PAY_PYAUAPL_XMLP_PKG SQL Statements

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

Line: 19

      SELECT
        LOOKUP_CODE,
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_CODE in ( 'C' , 'F' )
        AND LOOKUP_TYPE = 'AU_ADV_FLAG';

Line: 27

      SELECT
        LOOKUP_CODE,
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_CODE in ( 'Y' , 'N' )
        AND LOOKUP_TYPE = 'YES_NO';

Line: 35

      SELECT
        EMPLOYEE_NUMBER
      FROM
        PER_PEOPLE_F
      WHERE PERSON_ID = P_PERSON_ID;

Line: 41

      SELECT
        PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F
      WHERE PAYROLL_ID = P_PAYROLL_ID;

Line: 111

      SELECT
        PPA7.ACTION_STATUS
      FROM
        PAY_PAYROLLS_F PPF7,
        PER_ASSIGNMENTS_F PAA7,
        PAY_PAYROLL_ACTIONS PPA7,
        PAY_ASSIGNMENT_ACTIONS PAC7
      WHERE PPF7.PAYROLL_ID = PAA7.PAYROLL_ID
        AND PPA7.ACTION_TYPE = 'W'
        AND PPA7.PAYROLL_ACTION_ID = PAC7.PAYROLL_ACTION_ID
        AND PAA7.ASSIGNMENT_ID = PAC7.ASSIGNMENT_ID
        AND P_CP_LEAVE_START_DATE between PPA7.START_DATE
        AND PPA7.END_DATE
        AND P_CP_LEAVE_END_DATE between PPA7.START_DATE
        AND PPA7.END_DATE;