eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_FLEX_VALUE_SET_INFO dependencies on FND_NUMBER

Line 351: ,'N','fnd_number.number_to_canonical('||NVL(fvt.id_column_name,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
355: ,'AND '||NVL(fvt.id_column_name,fvt.value_column_name)||' = :$FLEX$.$$'||p_flex_value_set_name AS identification_clause

Line 535: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'

531: ||' ,NULL'
532: ||' ,NULL'
533: ||' ,NULL'
534: ||' FROM fnd_flex_values_vl ffv'
535: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'
536: ||' AND '||l_effective_date||' BETWEEN NVL(ffv.start_date_active,'||l_effective_date||')'
537: ||' AND NVL(ffv.end_date_active,'||l_effective_date||')'
538: ||' AND ffv.enabled_flag = ''Y'''
539: ||' ORDER BY ffv.flex_value';

Line 547: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'

543: ||' ,NULL'
544: ||' ,NULL'
545: ||' ,NULL'
546: ||' FROM fnd_flex_values_vl ffv'
547: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'
548: -- ||' AND '||l_effective_date||' BETWEEN NVL(ffv.start_date_active,'||l_effective_date||')'
549: -- ||' AND NVL(ffv.end_date_active,'||l_effective_date||')'
550: -- ||' AND ffv.enabled_flag = ''Y'''
551: ||' AND ffv.flex_value = :$FLEX$.'||p_flex_value_set_name;

Line 638: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'

634: ||' ,NULL'
635: ||' ,NULL'
636: ||' ,NULL'
637: ||' FROM fnd_flex_values_vl ffv'
638: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'
639: ||' AND '||l_effective_date||' BETWEEN NVL(ffv.start_date_active,'||l_effective_date||')'
640: ||' AND NVL(ffv.end_date_active,'||l_effective_date||')'
641: ||' AND ffv.enabled_flag = ''Y'''
642: ||' AND ffv.parent_flex_value_low = '||l_parent_value_set_name

Line 651: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'

647: ||' ,NULL'
648: ||' ,NULL'
649: ||' ,NULL'
650: ||' FROM fnd_flex_values_vl ffv'
651: ||' WHERE ffv.flex_value_set_id = fnd_number.canonical_to_number('||fnd_number.number_to_canonical(p_flex_value_set_id)||')'
652: ||' AND '||l_effective_date||' BETWEEN NVL(ffv.start_date_active,'||l_effective_date||')'
653: ||' AND NVL(ffv.end_date_active,'||l_effective_date||')'
654: ||' AND ffv.enabled_flag = ''Y'''
655: ||' AND ffv.parent_flex_value_low = '||l_parent_value_set_name