VIEW: APPS.PAY_US_GARN_FEE_RULES_F_V

Source

View Text - Preformatted

SELECT GFR.ROWID ROW_ID , GFR.FEE_RULE_ID , GFR.EFFECTIVE_START_DATE , GFR.EFFECTIVE_END_DATE , HR1.MEANING GARN_CATEGORY_NAME , GFR.GARN_CATEGORY , PSR.NAME STATE_NAME , GFR.STATE_CODE , GFR.ADDL_GARN_FEE_AMOUNT , GFR.CORRESPONDENCE_FEE , GFR.CREATOR_TYPE , GFR.FEE_AMOUNT , HR2.MEANING FEE_RULE_NAME , GFR.FEE_RULE , GFR.MAX_FEE_AMOUNT , GFR.PCT_CURRENT , GFR.TAKE_FEE_ON_PRORATION , GFR.LAST_UPDATE_DATE , GFR.LAST_UPDATED_BY , GFR.LAST_UPDATE_LOGIN , GFR.CREATED_BY , GFR.CREATION_DATE FROM HR_LOOKUPS HR1, HR_LOOKUPS HR2, PAY_STATE_RULES PSR, PAY_US_GARN_FEE_RULES_F GFR, FND_SESSIONS SES WHERE SES.SESSION_ID = USERENV('sessionid') AND SES.EFFECTIVE_DATE BETWEEN GFR.EFFECTIVE_START_DATE AND GFR.EFFECTIVE_END_DATE AND SUBSTR(PSR.JURISDICTION_CODE, 1, 2) = GFR.STATE_CODE AND HR1.LOOKUP_TYPE = 'US_GARN_EXMPT_CAT' AND HR1.LOOKUP_CODE = GFR.GARN_CATEGORY AND HR2.LOOKUP_TYPE = 'US_GARN_FEE_RULE' AND HR2.LOOKUP_CODE = GFR.FEE_RULE

View Text - HTML Formatted

SELECT GFR.ROWID ROW_ID
, GFR.FEE_RULE_ID
, GFR.EFFECTIVE_START_DATE
, GFR.EFFECTIVE_END_DATE
, HR1.MEANING GARN_CATEGORY_NAME
, GFR.GARN_CATEGORY
, PSR.NAME STATE_NAME
, GFR.STATE_CODE
, GFR.ADDL_GARN_FEE_AMOUNT
, GFR.CORRESPONDENCE_FEE
, GFR.CREATOR_TYPE
, GFR.FEE_AMOUNT
, HR2.MEANING FEE_RULE_NAME
, GFR.FEE_RULE
, GFR.MAX_FEE_AMOUNT
, GFR.PCT_CURRENT
, GFR.TAKE_FEE_ON_PRORATION
, GFR.LAST_UPDATE_DATE
, GFR.LAST_UPDATED_BY
, GFR.LAST_UPDATE_LOGIN
, GFR.CREATED_BY
, GFR.CREATION_DATE
FROM HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, PAY_STATE_RULES PSR
, PAY_US_GARN_FEE_RULES_F GFR
, FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN GFR.EFFECTIVE_START_DATE
AND GFR.EFFECTIVE_END_DATE
AND SUBSTR(PSR.JURISDICTION_CODE
, 1
, 2) = GFR.STATE_CODE
AND HR1.LOOKUP_TYPE = 'US_GARN_EXMPT_CAT'
AND HR1.LOOKUP_CODE = GFR.GARN_CATEGORY
AND HR2.LOOKUP_TYPE = 'US_GARN_FEE_RULE'
AND HR2.LOOKUP_CODE = GFR.FEE_RULE