View: PAY_STATUS_PROCESSING_RULES_D

Product:	PAY - Payroll
Description:	Used by DateTrack History
Implementation/DBA Data:	APPS.PAY_STATUS_PROCESSING_RULES_D

View Text

SELECT SRULE.STATUS_PROCESSING_RULE_ID
, SRULE.EFFECTIVE_START_DATE
, SRULE.EFFECTIVE_END_DATE
, STYPETL.USER_STATUS
, ETYPETL.ELEMENT_NAME
, FORM.FORMULA_NAME
, SRULE.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM PAY_ELEMENT_TYPES_F_TL ETYPETL
, PER_ASSIGNMENT_STATUS_TYPES_TL STYPETL
, PAY_STATUS_PROCESSING_RULES_F SRULE
, PER_ASSIGNMENT_STATUS_TYPES STYPE
, PAY_ELEMENT_TYPES_F ETYPE
, FF_FORMULAS_F FORM
, FND_USER FUSER
WHERE STYPE.ASSIGNMENT_STATUS_TYPE_ID = STYPETL.ASSIGNMENT_STATUS_TYPE_ID (+)
AND DECODE(STYPETL.ASSIGNMENT_STATUS_TYPE_ID
, NULL
, '1'
, STYPETL.LANGUAGE) = DECODE(STYPETL.ASSIGNMENT_STATUS_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND ETYPE.ELEMENT_TYPE_ID = ETYPETL.ELEMENT_TYPE_ID
AND ETYPETL.LANGUAGE = USERENV('LANG')
AND STYPE.ASSIGNMENT_STATUS_TYPE_ID (+)= SRULE.ASSIGNMENT_STATUS_TYPE_ID
AND ETYPE.ELEMENT_TYPE_ID = SRULE.ELEMENT_TYPE_ID
AND SRULE.EFFECTIVE_START_DATE BETWEEN ETYPE.EFFECTIVE_START_DATE
AND ETYPE.EFFECTIVE_END_DATE
AND FORM.FORMULA_ID (+)= SRULE.FORMULA_ID
AND SRULE.EFFECTIVE_START_DATE BETWEEN NVL (FORM.EFFECTIVE_START_DATE
, SRULE.EFFECTIVE_START_DATE)
AND NVL (FORM.EFFECTIVE_END_DATE
, SRULE.EFFECTIVE_START_DATE)
AND FUSER.USER_ID (+)= SRULE.LAST_UPDATED_BY

Columns