[Home] [Help]
1960: -- It will be person or BG pattern depending on the variables passed in
1961: --
1962: select start_date
1963: , end_date
1964: from hr_calendar_usages
1965: where purpose_usage_id||null = l_purpose_usage_id
1966: and primary_key_value = l_primary_key_value
1967: and end_date >= p_period_from
1968: and start_date <= p_period_to;