VIEW: APPS.HR_DE_LIABILITY_PREMIUMS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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