VIEW: APPS.PAY_STATUS_PROCESSING_RULES_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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