DBA Data[Home] [Help]

APPS.PQP_FTE_UTILITIES dependencies on HR_GENERAL

Line 276: RPAD(NVL(HR_GENERAL.DECODE_LOOKUP('FREQUENCY',p_output_file_record.frequency),' '),10,' ')||g_column_separator||

272: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_old_value),' '),20,' ')||g_column_separator||
273: RPAD(NVL(p_output_file_record.change_type,' '),15,' ')||g_column_separator||
274: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_new_value),' '),20,' ')||g_column_separator||
275: RPAD(NVL(TO_CHAR(p_output_file_record.normal_hours),' '),15,' ')||g_column_separator||
276: RPAD(NVL(HR_GENERAL.DECODE_LOOKUP('FREQUENCY',p_output_file_record.frequency),' '),10,' ')||g_column_separator||
277: RPAD(NVL(p_output_file_record.contract_type,' '),30,' ')||g_column_separator||
278: RPAD(NVL(p_output_file_record.annual_hours,' '),15,' ')||g_column_separator||
279: RPAD(NVL(p_output_file_record.period_divisor,' '),15,' ')||g_column_separator||
280: RPAD(p_output_file_record.message,255,' ')

Line 292: RPAD(NVL(HR_GENERAL.DECODE_LOOKUP('FREQUENCY',p_output_file_record.frequency),' '),10,' ')||g_column_separator||

288: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_old_value),' '),20,' ')||g_column_separator||
289: RPAD(NVL(p_output_file_record.change_type,' '),15,' ')||g_column_separator||
290: RPAD(NVL(TO_CHAR(p_output_file_record.FTE_new_value),' '),20,' ')||g_column_separator||
291: RPAD(NVL(TO_CHAR(p_output_file_record.normal_hours),' '),15,' ')||g_column_separator||
292: RPAD(NVL(HR_GENERAL.DECODE_LOOKUP('FREQUENCY',p_output_file_record.frequency),' '),10,' ')||g_column_separator||
293: RPAD(NVL(p_output_file_record.contract_type,' '),30,' ')||g_column_separator||
294: RPAD(NVL(p_output_file_record.annual_hours,' '),15,' ')||g_column_separator||
295: RPAD(NVL(p_output_file_record.period_divisor,' '),15,' ')||g_column_separator||
296: RPAD(p_output_file_record.message,255,' ')