Product: | PER - Human Resources |
---|---|
Description: | Displays Liability Premium Rates for a particular Internal and External Org(Liab Prov) relationship |
Implementation/DBA Data: | APPS.HR_DE_LIABILITY_PREMIUMS |
SELECT LIP.LIABILITY_PREMIUMS_ID
, LIP.EFFECTIVE_START_DATE
, LIP.EFFECTIVE_END_DATE
, LIP.ORGANIZATION_LINK_ID
, ORL.PARENT_ORGANIZATION_ID
, ORL.CHILD_ORGANIZATION_ID
, LIP.STD_PERCENTAGE
, LIP.CALCULATION_METHOD
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('DE_WORKING_HOURS_CALC_METHOD'
, LIP.CALCULATION_METHOD)
, 1
, 80)
, LIP.STD_WORKING_HOURS_PER_YEAR
, LIP.MAX_REMUNERATION
, LIP.ATTRIBUTE_CATEGORY
, LIP.ATTRIBUTE1
, LIP.ATTRIBUTE2
, LIP.ATTRIBUTE3
, LIP.ATTRIBUTE4
, LIP.ATTRIBUTE5
, LIP.ATTRIBUTE6
, LIP.ATTRIBUTE7
, LIP.ATTRIBUTE8
, LIP.ATTRIBUTE9
, LIP.ATTRIBUTE10
, LIP.ATTRIBUTE11
, LIP.ATTRIBUTE12
, LIP.ATTRIBUTE13
, LIP.ATTRIBUTE14
, LIP.ATTRIBUTE15
, LIP.ATTRIBUTE16
, LIP.ATTRIBUTE17
, LIP.ATTRIBUTE18
, LIP.ATTRIBUTE19
, LIP.ATTRIBUTE20
, LIP.LAST_UPDATED_BY
, LIP.LAST_UPDATE_LOGIN
, LIP.LAST_UPDATE_DATE
, LIP.CREATED_BY
, LIP.CREATION_DATE
, LIP.OBJECT_VERSION_NUMBER
FROM HR_DE_LIABILITY_PREMIUMS_F LIP
, HR_DE_ORGANIZATION_LINKS ORL
, FND_SESSIONS SES
WHERE LIP.ORGANIZATION_LINK_ID = ORL.ORGANIZATION_LINK_ID(+)
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN LIP.EFFECTIVE_START_DATE
AND LIP.EFFECTIVE_END_DATE