VIEW: APPS.PAY_STATUS_PROCESSING_RULES_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))