APPS.HR_FLEX_VALUE_SET_INFO dependencies on FND_DATE

Line 344: ,'D','fnd_date.date_to_displaydate('||fvt.value_column_name||')'

340: ,p_flex_value_set_name IN fnd_flex_value_sets.flex_value_set_name%TYPE
341: )
342: IS
343: SELECT DECODE(fvt.value_column_type
344: ,'D','fnd_date.date_to_displaydate('||fvt.value_column_name||')'
345: ,'N',fvt.value_column_name
346: ,fvt.value_column_name
347: ) AS value_column_name
348: ,NVL(fvt.meaning_column_name,'NULL') AS meaning_column_name

Line 350: ,'D','fnd_date.date_to_canonical('||NVL(fvt.id_column_name,fvt.value_column_name)||')'

346: ,fvt.value_column_name
347: ) AS value_column_name
348: ,NVL(fvt.meaning_column_name,'NULL') AS meaning_column_name
349: ,DECODE(NVL(fvt.id_column_type,fvt.value_column_type)
350: ,'D','fnd_date.date_to_canonical('||NVL(fvt.id_column_name,fvt.value_column_name)||')'
351: ,'N','fnd_number.number_to_canonical('||NVL(fvt.id_column_name,fvt.value_column_name)||')'
352: ,NVL(fvt.id_column_name,fvt.value_column_name)
353: ) AS id_column_name
354: ,NVL(fvt.id_column_type,fvt.value_column_type) AS id_column_type

Line 382: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';

378: --
379: -- Creating a character string for the SQL, so date should be converted to
380: -- character consistently
381: --
382: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';
383: --
384: FOR l_validation_table IN csr_validation_tables
385: (p_flex_value_set_id => p_flex_value_set_id
386: ,p_flex_value_set_name => p_flex_value_set_name

Line 533: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';

529: --
530: -- Creating a character string for the SQL, so date should be converted to
531: -- character consistently
532: --
533: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';
534: --
535: -- Build up SQL SELECT statements
536: --
537: p_validation_sql := 'SELECT ffv.flex_value_meaning'

Line 632: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';

628: --
629: -- Creating a character string for the SQL, so date should be converted to
630: -- character consistently
631: --
632: l_effective_date := 'fnd_date.canonical_to_date('''||fnd_date.date_to_canonical(p_effective_date)||''')';
633: --
634: -- Determine parent value set name
635: --
636: l_parent_value_set_name := ':$FLEX$.'||parent_value_set_name(p_flex_value_set_id);