APPS.PAY_PYAURECP_XMLP_PKG SQL Statements

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

Line: 5

      SELECT
        TO_DATE('01-07-' || SUBSTR(C_FIN_YR
                      ,1
                      ,4)
               ,'DD-MM-YYYY') FINANCIAL_YEAR_START,
        TO_DATE('30-06-' || SUBSTR(C_FIN_YR
                      ,6
                      ,4)
               ,'DD-MM-YYYY') FINANCIAL_YEAR_END,
        TO_DATE('01-04-' || SUBSTR(C_FIN_YR
                      ,1
                      ,4)
               ,'DD-MM-YYYY') FBT_YEAR_START,
        TO_DATE('30-06-' || SUBSTR(C_FIN_YR
                      ,1
                      ,4)
               ,'DD-MM-YYYY') FBT_YEAR_END
      FROM
        DUAL;

Line: 25

      SELECT
        NAME
      FROM
        HR_AU_LEG_EMP_V
      WHERE ORGANIZATION_ID = C_ORG_ID;

Line: 31

      SELECT
        PPF.PAYROLL_NAME
      FROM
        PAY_PAYROLLS_F PPF
      WHERE PPF.PAYROLL_ID = C_PAYROLL_ID
        AND PPF.EFFECTIVE_START_DATE = (
        SELECT
          MAX(PPF1.EFFECTIVE_START_DATE)
        FROM
          PAY_PAYROLLS_F PPF1
        WHERE PPF1.PAYROLL_ID = PPF.PAYROLL_ID );

Line: 43

      SELECT
        HL.MEANING
      FROM
        HR_LOOKUPS HL
      WHERE HL.LOOKUP_TYPE = 'AU_PS_EMPLOYEE_TYPE'
        AND HL.ENABLED_FLAG = 'Y'
        AND HL.LOOKUP_CODE = C_HL_CODE;

Line: 51

      SELECT
        PAA.ASSIGNMENT_NUMBER
      FROM
        PER_ASSIGNMENTS_F PAA
      WHERE PAA.ASSIGNMENT_ID = C_ASSIGNMENT_ID
        AND PAA.EFFECTIVE_START_DATE = (
        SELECT
          MAX(PAA1.EFFECTIVE_START_DATE)
        FROM
          PER_ASSIGNMENTS_F PAA1
        WHERE PAA1.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
          AND PAA1.EFFECTIVE_START_DATE <= CP_FIN_YR_END
          AND PAA1.EFFECTIVE_END_DATE >= CP_FIN_YR_START );

Line: 65

      SELECT
        GLOBAL_VALUE
      FROM
        FF_GLOBALS_F
      WHERE GLOBAL_NAME = C_NAME
        AND LEGISLATION_CODE = 'AU'
        AND C_YEAR_END BETWEEN EFFECTIVE_START_DATE
        AND EFFECTIVE_END_DATE;

Line: 74

      SELECT
        COUNT(ASSIGNMENT_ACTION_ID)
      FROM
        PAY_ASSIGNMENT_ACTIONS
      WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;

Line: 83

  select
    SUBSTR(argument1,INSTR(argument1,'=',1)+1,LENGTH(argument1)),
    SUBSTR(argument2,INSTR(argument2,'=',1)+1,LENGTH(argument2)),
    SUBSTR(argument3,INSTR(argument3,'=',1)+1,LENGTH(argument3)),
    SUBSTR(argument4,INSTR(argument4,'=',1)+1,LENGTH(argument4)),
    SUBSTR(argument5,INSTR(argument5,'=',1)+1,LENGTH(argument5)),
    SUBSTR(argument6,INSTR(argument6,'=',1)+1,LENGTH(argument6)),
    SUBSTR(argument7,INSTR(argument7,'=',1)+1,LENGTH(argument7)),
    SUBSTR(argument8,INSTR(argument8,'=',1)+1,LENGTH(argument8))
  into

  LP_PAYROLL_ACTION_ID,
  LP_ASSIGNMENT_ID,
  LP_BUSINESS_GROUP_ID,
  LP_EMPLOYEE_TYPE,
  LP_FINANCIAL_YEAR,
  LP_LST_YR_TERM,
  LP_PAYROLL_ID,
  LP_REGISTERED_EMPLOYER

    from FND_CONCURRENT_REQUESTS
where request_id= FND_GLOBAL.conc_request_id;

Line: 262

      SELECT
        HR.MEANING FIN_YEAR
      FROM
        PER_ASSIGNMENT_EXTRA_INFO PAE,
        HR_LOOKUPS HR
      WHERE PAE.AEI_INFORMATION_CATEGORY = 'HR_PS_ISSUE_DATE_AU'
        AND PAE.INFORMATION_TYPE = 'HR_PS_ISSUE_DATE_AU'
        AND PAE.ASSIGNMENT_ID = C_ASSIGNMENT_ID
        AND PAE.AEI_INFORMATION1 = TO_CHAR(C_FIN_DATE
             ,'YY')
        AND NVL(AEI_INFORMATION2
         ,C_TAX_UNIT_ID) = DECODE(AEI_INFORMATION2
            ,'-999'
            ,AEI_INFORMATION2
            ,C_TAX_UNIT_ID)
        AND PAE.AEI_INFORMATION1 = HR.LOOKUP_CODE
        AND HR.LOOKUP_TYPE = 'AU_PS_FINANCIAL_YEAR';

Line: 480

    DELETE FROM PAY_ASSIGNMENT_ACTIONS
     WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;

Line: 482

    DELETE FROM PAY_PAYROLL_ACTIONS
     WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;

Line: 490

      SELECT
        TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE
                                 ,15
                                 ,'0') || PAA.ASSIGNMENT_ACTION_ID)
                        ,16)) ASSIGNMENT_ACTION_ID
      FROM
        PAY_ASSIGNMENT_ACTIONS PAA,
        PAY_PAYROLL_ACTIONS PPA
      WHERE PAA.TAX_UNIT_ID = LP_REGISTERED_EMPLOYER
        AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
        AND PPA.PAYROLL_ID = NVL(LP_PAYROLL_ID
         ,PPA.PAYROLL_ID)
        AND PAA.ASSIGNMENT_ID = NVL(LP_ASSIGNMENT_ID
         ,PAA.ASSIGNMENT_ID)
        AND PPA.EFFECTIVE_DATE BETWEEN CP_FIN_YR_START
        AND CP_FIN_YR_END
        AND PAA.ACTION_STATUS = 'C'
        AND PPA.ACTION_STATUS = 'C'
        AND PPA.ACTION_TYPE in ( 'R' , 'Q' , 'I' , 'V' , 'B' );

Line: 513

    L_GROUP_OUTPUT_TAB.DELETE;