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.PER_ZA_UTILITY_PKG dependencies on FND_DATE

Line 303: , 'D', to_char(fnd_date.canonical_to_date(p_row_value))

299: and R.effective_end_date
300: and R.legislation_code = g_leg_code
301: and decode
302: ( TAB.user_key_units
303: , 'D', to_char(fnd_date.canonical_to_date(p_row_value))
304: , 'N', p_row_value
305: , 'T', upper (p_row_value)
306: , null
307: ) = decode

Line 309: , 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name))

305: , 'T', upper (p_row_value)
306: , null
307: ) = decode
308: ( TAB.user_key_units
309: , 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name))
310: , 'N', R.row_low_range_or_name
311: , 'T', upper (R.row_low_range_or_name)
312: , null
313: )

Line 434: , 'D', to_char(fnd_date.canonical_to_date(p_row_value))

430: and R.effective_end_date
431: and R.business_group_id = p_business_group_id
432: and decode
433: ( TAB.user_key_units
434: , 'D', to_char(fnd_date.canonical_to_date(p_row_value))
435: , 'N', p_row_value
436: , 'T', upper (p_row_value)
437: , null
438: ) = decode

Line 440: , 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name))

436: , 'T', upper (p_row_value)
437: , null
438: ) = decode
439: ( TAB.user_key_units
440: , 'D', to_char(fnd_date.canonical_to_date(R.row_low_range_or_name))
441: , 'N', R.row_low_range_or_name
442: , 'T', upper (R.row_low_range_or_name)
443: , null
444: )