HXT Holiday Calendar Table

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Holiday Calendar Table Report (XML)
Short Name: HXT957A_XML
DB package: HXT_HXT957A_XMLP_PKG
Run HXT Holiday Calendar Table and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT ALL
 HXT_HOLIDAY_CALENDARS.ID, 
 HXT_HOLIDAY_CALENDARS.NAME, HXT_HOLIDAY_CALENDARS.DESCRIPTION, 
HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, 
HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE,
HXT_HOLIDAY_CALENDARS.organization_id,
NULL dummy, 
	HXT_HXT957A_XMLP_PKG.org_nameformula(HXT_HOLIDAY_CALENDARS.organization_id) ORG_NAME, 
	HXT_HXT957A_XMLP_PKG.earn_typeformula(HXT_HOLIDAY_CALENDARS.ELEMENT_TYPE_ID, HXT_HOLIDAY_CALENDARS.EFFECTIVE_START_DATE, HXT_HOLIDAY_CALENDARS.EFFECTIVE_END_DATE) EARN_TYPE
FROM HXT_HOLIDAY_CALENDARS
ORDER BY HXT_HOLIDAY_CALENDARS.NAME ASC
Parameter Name SQL text Validation
Start Date 
 
 Date
End Date 
 
 Date
Download
 
Related Blitz Reports
HXT Earning Policy Table Listing PAY RTI - Employer Payment Summary Output BOM Calendars PSB Budget Calendar Listing PAY RTI - Employer Payment Summary Output 2013/14 HXT Organization Variance Calc HXT Premium Elg. Policy Tbl List HXT Earning Variance Calculation HXT Location Variance Calculation
Blitz Report™

Blitz Report™ provides multiple benefits: