APPS.PAY_PAYKRHCL_XMLP_PKG SQL Statements

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

Line: 6

  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))
  into
    LP_PAYROLL_ACTION_ID,  LP_BP_HI_NUMBER ,  LP_REPORTED_DATE
  from FND_CONCURRENT_REQUESTS
  where request_id= FND_GLOBAL.conc_request_id;

Line: 46

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

      SELECT
        CURRENCY_CODE
      FROM
        FND_CURRENCIES
      WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;

Line: 96

      SELECT
        USER_ENTITY_ID
      FROM
        FF_USER_ENTITIES
      WHERE LEGISLATION_CODE = 'KR'
        AND USER_ENTITY_NAME = P_USER_ENTITY_NAME;

Line: 158

      SELECT
        HOU1.NAME
      FROM
        HR_ORGANIZATION_UNITS HOU1,
        PAY_PAYROLL_ACTIONS PPA,
        HR_ORGANIZATION_INFORMATION HOI2
      WHERE PPA.PAYROLL_ACTION_ID = LP_PAYROLL_ACTION_ID
        AND HOU1.BUSINESS_GROUP_ID = PPA.BUSINESS_GROUP_ID
        AND HOU1.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
        AND HOI2.ORG_INFORMATION_CONTEXT = 'KR_HI_INFORMATION'
        AND HOI2.ORG_INFORMATION1 = LP_BP_HI_NUMBER;