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