101: end_date,
102: status,
103: period_name||
104: ' ('||
105: fnd_date.date_to_displaydate (start_date)||
106: ' - '||
107: fnd_date.date_to_displaydate (end_date)||
108: ')' DISPLAY_PERIOD
109: from per_time_periods
103: period_name||
104: ' ('||
105: fnd_date.date_to_displaydate (start_date)||
106: ' - '||
107: fnd_date.date_to_displaydate (end_date)||
108: ')' DISPLAY_PERIOD
109: from per_time_periods
110: where payroll_id = p_payroll_id
111: and p_effective_date between start_date and end_date;