DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on FND_DATE

Line 114: -- fnd_date.date_to_displaydate (start_date)|| /* COMMENTED FOR BUG 11830805 */

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 */

Line 115: -- fnd_date.date_to_displaydate (start_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:

Line 117: -- fnd_date.date_to_displaydate (end_date)|| /* COMMENTED FOR BUG 11830805 */

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

Line 118: -- fnd_date.date_to_displaydate (end_date, calendar_aware=>2)|| /* FOR BUG 11830805 */

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

Line 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)|| ')';

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