Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_US_GARN_FEE_RULES_F_V |
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