View: PAY_STATUS_PROCESSING_RULES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_STATUS_PROCESSING_RULES_V

View Text

SELECT RULE.STATUS_PROCESSING_RULE_ID
, RULE.EFFECTIVE_START_DATE
, RULE.EFFECTIVE_END_DATE
, RULE.BUSINESS_GROUP_ID
, RULE.LEGISLATION_CODE
, RULE.ELEMENT_TYPE_ID
, RULE.ASSIGNMENT_STATUS_TYPE_ID
, RULE.FORMULA_ID
, RULE.PROCESSING_RULE
, RULE.COMMENT_ID
, RULE.LEGISLATION_SUBGROUP
, RULE.LAST_UPDATE_DATE
, RULE.LAST_UPDATED_BY
, RULE.LAST_UPDATE_LOGIN
, RULE.CREATED_BY
, RULE.CREATION_DATE
, RULE.ROWID ROW_ID
, RULE.FORMULA_ID SAVED_FORMULA_ID
, FORMULA.FORMULA_NAME
, NVL(AMENDED.USER_STATUS
, ORIGINAL.USER_STATUS) USER_STATUS
FROM PAY_STATUS_PROCESSING_RULES_F RULE
, PAY_ASS_STATUS_TYPES_PLUS_STD ORIGINAL
, PER_ASS_STATUS_TYPE_AMENDS AMENDED
, FF_FORMULAS_F FORMULA
, FND_SESSIONS CURRENT_SESSION
WHERE FORMULA.FORMULA_ID(+) = RULE.FORMULA_ID
AND ORIGINAL.ASSIGNMENT_STATUS_TYPE_ID = AMENDED.ASSIGNMENT_STATUS_TYPE_ID(+)
AND (RULE.ASSIGNMENT_STATUS_TYPE_ID = ORIGINAL.ASSIGNMENT_STATUS_TYPE_ID OR (RULE.ASSIGNMENT_STATUS_TYPE_ID IS NULL
AND ORIGINAL.ASSIGNMENT_STATUS_TYPE_ID IS NULL
AND ((NVL(ORIGINAL.LOOKUP_CODE
, 'X')= 'STANDARD'
AND RULE.PROCESSING_RULE='P') OR (NVL(ORIGINAL.LOOKUP_CODE
, 'X')='BAL_ADJUST'
AND RULE.PROCESSING_RULE='B'))))
AND (CURRENT_SESSION.SESSION_ID = USERENV('SESSIONID')
AND CURRENT_SESSION.EFFECTIVE_DATE BETWEEN RULE.EFFECTIVE_START_DATE
AND RULE.EFFECTIVE_END_DATE
AND (FORMULA.FORMULA_ID IS NULL OR CURRENT_SESSION.EFFECTIVE_DATE BETWEEN FORMULA.EFFECTIVE_START_DATE
AND FORMULA.EFFECTIVE_END_DATE))

Columns