110: period_name as DISPLAY_PERIOD
111: /* commented for the bug 12388097 */
112: -- period_name||
113: -- ' ('||
114: -- fnd_date.date_to_displaydate (start_date)|| /* COMMENTED FOR BUG 11830805 */
115: -- fnd_date.date_to_displaydate (start_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
116: -- ' - '||
117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */
118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
111: /* commented for the bug 12388097 */
112: -- period_name||
113: -- ' ('||
114: -- fnd_date.date_to_displaydate (start_date)|| /* COMMENTED FOR BUG 11830805 */
115: -- fnd_date.date_to_displaydate (start_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
116: -- ' - '||
117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */
118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
119:
113: -- ' ('||
114: -- fnd_date.date_to_displaydate (start_date)|| /* COMMENTED FOR BUG 11830805 */
115: -- fnd_date.date_to_displaydate (start_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
116: -- ' - '||
117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */
118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
119:
120: -- ')' DISPLAY_PERIOD
121: from per_time_periods
114: -- fnd_date.date_to_displaydate (start_date)|| /* COMMENTED FOR BUG 11830805 */
115: -- fnd_date.date_to_displaydate (start_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
116: -- ' - '||
117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */
118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */
119:
120: -- ')' DISPLAY_PERIOD
121: from per_time_periods
122: where payroll_id = p_payroll_id
138: p_period_status,
139: p_display_period;
140:
141: /* added for Bug 12388097 */
142: p_display_period := p_display_period || ' ('|| fnd_date.date_to_displaydate (p_start_date, calendar_aware=>2)|| ' - '|| fnd_date.date_to_displaydate (p_end_date, calendar_aware=>2)|| ')';
143: --
144: close asgt_payroll_period;
145: --
146: else -- no payroll information exists so nullify 'out' parameters