eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYAURECD_XMLP_PKG SQL Statements

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

Line: 10


  select concurrent_program_name into Rep_name  from fnd_concurrent_programs fc,FND_CONCURRENT_REQUESTS fn
where  fn.concurrent_program_id=fc.concurrent_program_id
and request_id= FND_GLOBAL.conc_request_id;

Line: 14


  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)),
  substr(argument18,instr(argument18,'=',1)+1,LENGTH(argument18)),
  substr(argument19,instr(argument19,'=',1)+1,LENGTH(argument19)),
  substr(argument20,instr(argument20,'=',1)+1,LENGTH(argument20)),
  substr(argument21,instr(argument21,'=',1)+1,LENGTH(argument21))
  into
  LP_PAYROLL_ACTION_ID,
  LP_BUSINESS_GROUP_ID,
  LP_ORGANIZATION_ID,
  LP_PAYROLL_ID,
  LP_REGISTERED_EMPLOYER,
  LP_ASSIGNMENT_ID,
  LP_START_DATE_D,
  LP_END_DATE_D,
  LP_PAYROLL_RUN_ID,
  LP_PERIOD_END_DATE_D,
  LP_EMPLOYEE_TYPE,
  LP_YTD_TOTALS,
  LP_ZERO_RECORDS,
  LP_NEGATIVE_RECORDS,
  LP_SORT_ORDER_1,
  LP_SORT_ORDER_2,
  LP_SORT_ORDER_3,
  LP_SORT_ORDER_4,
  P_PAYSUM_FLAG,
  LP_LST_YEAR_TERM,
  LP_DELETE_ACTIONS

    from FND_CONCURRENT_REQUESTS
where request_id= FND_GLOBAL.conc_request_id;

Line: 64


  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)),
  substr(argument18,instr(argument18,'=',1)+1,LENGTH(argument18)),
  substr(argument21,instr(argument21,'=',1)+1,LENGTH(argument21))
  into
  LP_PAYROLL_ACTION_ID,
  LP_BUSINESS_GROUP_ID,
  LP_ORGANIZATION_ID,
  LP_PAYROLL_ID,
  LP_REGISTERED_EMPLOYER,
  LP_ASSIGNMENT_ID,
  LP_START_DATE_D,
  LP_END_DATE_D,
  LP_PAYROLL_RUN_ID,
  LP_PERIOD_END_DATE_D,
  LP_EMPLOYEE_TYPE,
  LP_YTD_TOTALS,
  LP_ZERO_RECORDS,
  LP_NEGATIVE_RECORDS,
  LP_SORT_ORDER_1,
  LP_SORT_ORDER_2,
  LP_SORT_ORDER_3,
  LP_SORT_ORDER_4,
  LP_DELETE_ACTIONS

    from FND_CONCURRENT_REQUESTS
where request_id= FND_GLOBAL.conc_request_id;

Line: 199


    IF LP_DELETE_ACTIONS = 'Y' THEN
      BEGIN
        DELETE FROM PAY_ACTION_INFORMATION
         WHERE ACTION_INFORMATION_CATEGORY = 'AU_EMPLOYEE_RECON_DETAILS'
           AND ACTION_CONTEXT_ID = LP_PAYROLL_ACTION_ID;

Line: 205


          DELETE FROM PAY_ACTION_INFORMATION
           WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_ELEMENT_RECON_DETAILS' , 'AU_BALANCE_RECON_DETAILS_YTD' , 'AU_PS_BALANCE_RECON_DETAILS' )
             AND ACTION_CONTEXT_ID in (
             SELECT
               PAA.ASSIGNMENT_ACTION_ID
             FROM
               PAY_ASSIGNMENT_ACTIONS PAA
             WHERE PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
               AND PAA.ACTION_STATUS = 'C' );

Line: 215


          DELETE FROM PAY_ACTION_INFORMATION
           WHERE ACTION_INFORMATION_CATEGORY in ( 'AU_ELEMENT_RECON_DETAILS' , 'AU_BALANCE_RECON_DETAILS_RUN' , 'AU_BALANCE_RECON_DETAILS_YTD' )
             AND ACTION_CONTEXT_ID in (
             SELECT
               PAA.ASSIGNMENT_ACTION_ID
             FROM
               PAY_ASSIGNMENT_ACTIONS PAA
             WHERE PAA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
               AND PAA.ACTION_STATUS = 'C' );

Line: 224


          DELETE FROM PAY_ACTION_INFORMATION
           WHERE ACTION_INFORMATION_CATEGORY = 'AU_ARCHIVE_ASG_DETAILS'
             AND ACTION_INFORMATION2 = TO_CHAR(LP_PAYROLL_ACTION_ID);

Line: 233


        DELETE FROM PAY_ASSIGNMENT_ACTIONS PAA
         WHERE PAA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;

Line: 235


        DELETE FROM PAY_PAYROLL_ACTIONS PPA
         WHERE PPA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID;

Line: 256


      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: 277


      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;

Line: 319


      SELECT
        SUBSTR(PPF.FULL_NAME
              ,1
              ,80)
      FROM
        PER_PEOPLE_F PPF,
        PER_ASSIGNMENTS_F PAF
      WHERE PAF.PERSON_ID = PPF.PERSON_ID
        AND PAF.ASSIGNMENT_ID = C_ASS_ID;

Line: 342


      SELECT
        SUBSTR(NAME
              ,1
              ,80)
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = C_LEG_EMP_ID;

Line: 382


      SELECT
        SUBSTR(NAME
              ,1
              ,80)
      FROM
        HR_ORGANIZATION_UNITS
      WHERE ORGANIZATION_ID = C_ORGANIZATION_ID;

Line: 403


      SELECT
        SUBSTR(PAYROLL_NAME
              ,1
              ,80)
      FROM
        PAY_ALL_PAYROLLS_F
      WHERE PAYROLL_ID = C_PAYROLL_ID;

Line: 424


      SELECT
        SUBSTR(PAP.PAYROLL_NAME
              ,1
              ,71 - LENGTH(PTP.PERIOD_NAME) - LENGTH(HRL.MEANING)) || ' - ' || PTP.PERIOD_NAME || ' (' || HRL.MEANING || ' ' || TO_CHAR(PPA.DISPLAY_RUN_NUMBER) || ')' DISPLAY
      FROM
        PAY_ALL_PAYROLLS_F PAP,
        PER_TIME_PERIODS PTP,
        PAY_PAYROLL_ACTIONS PPA,
        HR_LOOKUPS HRL
      WHERE PPA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
        AND PAP.PAYROLL_ID = PPA.PAYROLL_ID
        AND PAP.PAYROLL_ID = PTP.PAYROLL_ID
        AND PPA.DATE_EARNED between PTP.START_DATE
        AND PTP.END_DATE
        AND HRL.LOOKUP_TYPE = 'ACTION_TYPE'
        AND HRL.LOOKUP_CODE = PPA.ACTION_TYPE;