APPS.PAY_PYAUPYT_XMLP_PKG SQL Statements

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

Line: 6

      DELETE FROM PAY_ACTION_INFORMATION
       WHERE ACTION_INFORMATION_CATEGORY = 'AU_PAYROLL_TAX_EMPLOYEE_DETAILS'
         AND ACTION_CONTEXT_ID = P_PAYROLL_ACTION_ID_LP;

Line: 9

      DELETE FROM PAY_ACTION_INFORMATION
       WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_PAYROLL_TAX_DGE_DETAILS' , 'AU_PAYROLL_TAX_BALANCE_DETAILS_YTD' )
         AND ACTION_CONTEXT_ID in (
         SELECT
           PAA.ASSIGNMENT_ACTION_ID
         FROM
           PAY_ASSIGNMENT_ACTIONS PAA
         WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP );

Line: 17

      DELETE FROM PAY_ACTION_INFORMATION
       WHERE ACTION_INFORMATION_CATEGORY = 'AU_ARCHIVE_ASG_DETAILS'
         AND ACTION_INFORMATION2 = P_PAYROLL_ACTION_ID_LP;

Line: 20

      DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
       WHERE PAA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP;

Line: 22

      DELETE FROM PAY_PAYROLL_ACTIONS PPA
       WHERE PPA.PAYROLL_ACTION_ID = P_PAYROLL_ACTION_ID_LP;

Line: 41

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'AU_STATE'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_TAX_STATE_LP;

Line: 49

      SELECT
        MEANING
      FROM
        HR_LOOKUPS
      WHERE LOOKUP_TYPE = 'AU_PAYROLL_TAX_REPORT_TYPE'
        AND ENABLED_FLAG = 'Y'
        AND LOOKUP_CODE = P_REPORT_TYPE_LP;

Line: 57

      SELECT
        NAME
      FROM
        HR_AU_LEG_EMP_V
      WHERE ORGANIZATION_ID = P_LEGAL_EMPLOYER_LP;

Line: 63

      SELECT
        ORG_INFORMATION3
      FROM
        HR_ORGANIZATION_UNITS HOU,
        HR_ORGANIZATION_INFORMATION HOI
      WHERE HOI.ORGANIZATION_ID = P_LEGAL_EMPLOYER_LP
        AND HOI.ORG_INFORMATION2 = P_TAX_STATE_LP
        AND HOI.ORG_INFORMATION_CONTEXT = 'AU_PAYROLL_TAX_DGE';

Line: 74

     SELECT 'X'
     FROM FND_SESSIONS
     WHERE SESSION_ID = USERENV('SESSIONID');

Line: 81

  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)),
  SUBSTR(argument9,INSTR(argument9,'=',1)+1,LENGTH(argument9)),
  SUBSTR(argument10,INSTR(argument10,'=',1)+1,LENGTH(argument10)),
  SUBSTR(argument11,INSTR(argument11,'=',1)+1,LENGTH(argument11)),
  SUBSTR(argument12,INSTR(argument12,'=',1)+1,LENGTH(argument12)),
  SUBSTR(argument13,INSTR(argument13,'=',1)+1,LENGTH(argument13)),
  SUBSTR(argument14,INSTR(argument14,'=',1)+1,LENGTH(argument14)),
  SUBSTR(argument15,INSTR(argument15,'=',1)+1,LENGTH(argument15)),
  SUBSTR(argument16,INSTR(argument16,'=',1)+1,LENGTH(argument16)),
  SUBSTR(argument17,INSTR(argument17,'=',1)+1,LENGTH(argument17))
  into
  P_PAYROLL_ACTION_ID_LP
  ,
  P_BUSINESS_GROUP_ID_LP,
  P_LEGAL_EMPLOYER_LP
  ,
  P_PERIOD_LP_1,
  P_START_DATE_LP_1,
  P_END_DATE_LP_1,
  P_TAX_STATE_LP,
  P_ACT_LP,
  P_QLD_LP,
  P_SA_LP,
  P_TAS_LP,
  P_VIC_LP ,
  P_WA_LP ,
  P_NSW_LP,
  P_NT_LP,
  P_REPORT_TYPE_LP ,
  P_REPORT_NAME_LP

    from FND_CONCURRENT_REQUESTS
where request_id= FND_GLOBAL.conc_request_id;

Line: 172

           INSERT INTO FND_SESSIONS (SESSION_ID, EFFECTIVE_DATE) VALUES (USERENV('SESSIONID'),TRUNC(P_START_DATE));

Line: 182

      SELECT
        ORG_INFORMATION9
      FROM
        HR_ORGANIZATION_INFORMATION
      WHERE ORGANIZATION_ID = C_BUSINESS_GROUP_ID
        AND ORG_INFORMATION9 is not null
        AND ORG_INFORMATION_CONTEXT = 'Business Group Information';

Line: 203

      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;