[Home] [Help]
1854: -- It will be person or BG pattern depending on the variables passed in
1855: --
1856: select start_date
1857: , end_date
1858: from hr_calendar_usages
1859: where purpose_usage_id||null = l_purpose_usage_id
1860: and primary_key_value = l_primary_key_value
1861: and end_date >= p_period_from
1862: and start_date <= p_period_to;