View: PAY_EMEA_PAYMNTS_ACTION_INFO_V

Product:	PAY - Payroll
Description:	Used to support online payslip
Implementation/DBA Data:	APPS.PAY_EMEA_PAYMNTS_ACTION_INFO_V

View Text

SELECT /*+ ORDERED INDEX(LCK PAY_ACTION_INTERLOCKS_PK) INDEX(PAA1 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PAA2 PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PPA PAY_PAYROLL_ACTIONS_PK) INDEX(PAI PAY_ACTION_INFORMATION_N2) INDEX(PET.PAC PAY_ACTION_INTERLOCKS_PK) INDEX(PET.PAA PAY_ASSIGNMENT_ACTIONS_PK) INDEX(PET.PPA PAY_PAYROLL_ACTIONS_PK) INDEX(PET.PET PAY_ELEMENT_TYPES_F_PK) INDEX(PET.PIV PAY_INPUT_VALUES_F_UK2) INDEX(PET.PRR PAY_RUN_RESULTS_N50) INDEX(PET.PRV PAY_RUN_RESULT_VALUES_PK) USE_NL(LCK
, PAA1
, PAA2
, PPA
, PAI) */ /* HINTS ADDED TO RESOLVE PERFORMANCE BUG 2421978 */ LCK.LOCKING_ACTION_ID
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PET.RESULT_VALUE VALUE
, PET.RESULT_VALUE
FROM PAY_ACTION_INTERLOCKS LCK
, PAY_ASSIGNMENT_ACTIONS PAA1
, PAY_ASSIGNMENT_ACTIONS PAA2
, PAY_PAYROLL_ACTIONS PPA
, PAY_ACTION_INFORMATION PAI
, PAY_EMEA_PAYMENT_VALUES_V PET
WHERE LCK.LOCKED_ACTION_ID = PAA1.ASSIGNMENT_ACTION_ID
AND PAA1.SOURCE_ACTION_ID IS NULL
AND PAA1.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE IN ('P'
, 'U')
AND PPA.PAYROLL_ACTION_ID = NVL (PAI.ACTION_INFORMATION1
, PPA.PAYROLL_ACTION_ID)
AND PAI.ACTION_CONTEXT_TYPE = 'PA'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMEA ELEMENT DEFINITION'
AND PAA1.ASSIGNMENT_ACTION_ID = PET.ASSIGNMENT_ACTION_ID
AND PET.ELEMENT_TYPE_ID = PAI.ACTION_INFORMATION2
AND PET.INPUT_VALUE_ID = PAI.ACTION_INFORMATION3
AND LCK.LOCKING_ACTION_ID = PAA2.ASSIGNMENT_ACTION_ID
AND PAA2.PAYROLL_ACTION_ID = PAI.ACTION_CONTEXT_ID

Columns