The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MIN(PPA_ARC.START_DATE) START_DATE
FROM
PAY_ASSIGNMENT_ACTIONS PAA_P30,
PAY_ACTION_INTERLOCKS PAI_P30,
PAY_ASSIGNMENT_ACTIONS PAA_ARC,
PAY_PAYROLL_ACTIONS PPA_ARC
WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
AND PPA_ARC.PAYROLL_ACTION_ID = PAA_ARC.PAYROLL_ACTION_ID;
SELECT
SUBSTR(PPA_P30.LEGISLATIVE_PARAMETERS
,INSTR(PPA_P30.LEGISLATIVE_PARAMETERS
,'END_DATE=') + 9
,10) END_DATE
FROM
PAY_PAYROLL_ACTIONS PPA_P30
WHERE PPA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID;
SELECT
TO_DATE(RULE_MODE || '/' || TO_CHAR(VP_REPORT_END_DATE
,'YYYY')
,'dd/mm/yyyy')
FROM
PAY_LEGISLATION_RULES
WHERE LEGISLATION_CODE = 'IE'
AND RULE_TYPE = 'L';
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';
SELECT
CURRENCY_CODE
FROM
FND_CURRENCIES
WHERE ISSUING_TERRITORY_CODE = C_TERRITORY_CODE;
SELECT
PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
FROM
PAY_ASSIGNMENT_ACTIONS PAA_P30,
PAY_ACTION_INTERLOCKS PAI_P30,
PAY_ASSIGNMENT_ACTIONS PAA_ARC,
PAY_ACTION_INFORMATION PACT_YTDBAL,
PAY_DEFINED_BALANCES PDB_YTDBAL,
PAY_BALANCE_TYPES PBT_YTDBAL,
PAY_BALANCE_DIMENSIONS PBD_YTDBAL,
PAY_ASSIGNMENT_ACTIONS PAA_SRC,
PAY_PAYROLL_ACTIONS PPA_SRC
WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
AND PACT_YTDBAL.ACTION_INFORMATION_CATEGORY = 'EMEA BALANCES'
AND PACT_YTDBAL.ACTION_CONTEXT_ID = VP_ACTION_CONTEXT_ID
AND PACT_YTDBAL.ACTION_CONTEXT_ID = PAA_ARC.ASSIGNMENT_ACTION_ID
AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
AND PDB_YTDBAL.DEFINED_BALANCE_ID = PACT_YTDBAL.ACTION_INFORMATION1
AND PDB_YTDBAL.BALANCE_TYPE_ID = PBT_YTDBAL.BALANCE_TYPE_ID
AND PBT_YTDBAL.BALANCE_NAME = VP_BALANCE_NAME
AND PBD_YTDBAL.DIMENSION_NAME = VP_DIMENSION_NAME
AND PBD_YTDBAL.BALANCE_DIMENSION_ID = PDB_YTDBAL.BALANCE_DIMENSION_ID
AND PBT_YTDBAL.LEGISLATION_CODE = 'IE'
AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
AND PAA_SRC.ASSIGNMENT_ACTION_ID = PACT_YTDBAL.SOURCE_ID
AND PAA_SRC.PAYROLL_ACTION_ID = PPA_SRC.PAYROLL_ACTION_ID
AND PPA_SRC.EFFECTIVE_DATE <= VP_EFFECTIVE_DATE
ORDER BY
PACT_YTDBAL.EFFECTIVE_DATE,
PACT_YTDBAL.ACTION_CONTEXT_ID,
NVL(PACT_YTDBAL.ACTION_INFORMATION5
,0);
SELECT
PPA.PAYROLL_ACTION_ID PREV_DATA_LOCK_ID,
TO_DATE(SUBSTR(PPA.LEGISLATIVE_PARAMETERS
,INSTR(PPA.LEGISLATIVE_PARAMETERS
,'END_DATE=') + 9
,10)
,'YYYY/MM/DD')
FROM
PAY_PAYROLL_ACTIONS PPA,
PAY_ASSIGNMENT_ACTIONS PAA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PPA.REPORT_TYPE = 'IEP30_PRGLOCK'
AND PAA.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
AND PAA.ASSIGNMENT_ACTION_ID = (
SELECT
TO_NUMBER(SUBSTR(MAX(LPAD(PAA2.ACTION_SEQUENCE
,15
,'0') || PAA2.ASSIGNMENT_ACTION_ID)
,16))
FROM
PAY_PAYROLL_ACTIONS PPA2,
PAY_ASSIGNMENT_ACTIONS PAA2
WHERE PPA2.PAYROLL_ACTION_ID = PAA2.PAYROLL_ACTION_ID
AND PPA2.REPORT_TYPE = 'IEP30_PRGLOCK'
AND PAA2.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
AND PPA2.PAYROLL_ACTION_ID <> VP_PAYROLL_ACTION_ID
AND TO_DATE(SUBSTR(PPA2.LEGISLATIVE_PARAMETERS
,INSTR(PPA2.LEGISLATIVE_PARAMETERS
,'END_DATE=') + 9
,10)
,'YYYY/MM/DD') BETWEEN VP_TAX_START_DATE
AND VP_REPORT_END_DATE )
ORDER BY
PPA.PAYROLL_ACTION_ID;
SELECT
FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(MAX(LPAD(PAA_RUN.ACTION_SEQUENCE
,15
,'0') || PACT_YTDBAL.ACTION_CONTEXT_ID)
,16))
FROM
PAY_ASSIGNMENT_ACTIONS PAA_P30,
PAY_ACTION_INTERLOCKS PAI_P30,
PAY_ASSIGNMENT_ACTIONS PAA_ARC,
PAY_ACTION_INFORMATION PACT_YTDBAL,
PAY_ACTION_INTERLOCKS PAI_ARC,
PAY_ASSIGNMENT_ACTIONS PAA_RUN,
PAY_PAYROLL_ACTIONS PPA_RUN
WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID
AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID
AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKED_ACTION_ID
AND PAA_ARC.ASSIGNMENT_ACTION_ID = PAI_ARC.LOCKING_ACTION_ID
AND PACT_YTDBAL.ACTION_CONTEXT_ID = PAA_ARC.ASSIGNMENT_ACTION_ID
AND PAA_RUN.ASSIGNMENT_ACTION_ID = PAI_ARC.LOCKED_ACTION_ID
AND PACT_YTDBAL.ACTION_CONTEXT_TYPE = 'AAP'
AND PAA_RUN.SOURCE_ACTION_ID IS NULL
AND PAA_RUN.PAYROLL_ACTION_ID = PPA_RUN.PAYROLL_ACTION_ID
AND PPA_RUN.ACTION_TYPE in ( 'R' , 'Q' );
SELECT
PAYROLL_NAME
FROM
PAY_PAYROLLS_F
WHERE PAYROLL_ID = VP_PAYROLL_ID;