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.SSP_SSP_PKG dependencies on HR_CHKFMT

Line 3696: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3692: entry.assignment_id,
3693: entry.effective_start_date,
3694: entry.effective_end_date,
3695: max(decode(inp.name,c_rate_name,
3696: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3697: g_SSP_correction.input_currency_code)),null)) RATE,
3698: /* Use the SSP_correction's input_currency_code as *
3699: * the SSP_legislation global may not be populated */
3700: -------------------------------------------------------------------------

Line 3710: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */

3706: -- which will convert the display format to a date. --
3707: -- This will fix bug 1020757. --
3708: -------------------------------------------------------------------------
3709: /* max(decode(inp.name,c_from_name, */
3710: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3711: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_FROM, */
3712: /* max(decode(inp.name,c_to_name, */
3713: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3714: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */

Line 3713: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */

3709: /* max(decode(inp.name,c_from_name, */
3710: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3711: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_FROM, */
3712: /* max(decode(inp.name,c_to_name, */
3713: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3714: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3715: max(decode(inp.name,c_from_name,
3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3717: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,

Line 3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,

3712: /* max(decode(inp.name,c_to_name, */
3713: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3714: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3715: max(decode(inp.name,c_from_name,
3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3717: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3718: max(decode(inp.name,c_to_name,
3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3720: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,

Line 3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,

3715: max(decode(inp.name,c_from_name,
3716: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3717: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3718: max(decode(inp.name,c_to_name,
3719: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3720: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3721: -- End of Changes for bug 1020757
3722: ------------------------------------------------------------------------
3723: max(decode(inp.name,c_amount_name,

Line 3724: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3720: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3721: -- End of Changes for bug 1020757
3722: ------------------------------------------------------------------------
3723: max(decode(inp.name,c_amount_name,
3724: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3725: g_SSP_correction.input_currency_code)),null)) AMOUNT,
3726: max(decode(inp.name,c_withheld_days_name,
3727: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3728: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,

Line 3727: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3723: max(decode(inp.name,c_amount_name,
3724: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3725: g_SSP_correction.input_currency_code)),null)) AMOUNT,
3726: max(decode(inp.name,c_withheld_days_name,
3727: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3728: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,
3729: max(decode(inp.name,c_SSP_weeks_name,
3730: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3731: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,

Line 3730: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3726: max(decode(inp.name,c_withheld_days_name,
3727: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3728: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,
3729: max(decode(inp.name,c_SSP_weeks_name,
3730: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3731: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,
3732: max(decode(inp.name,c_SSP_days_due_name,
3733: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3734: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,

Line 3733: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3729: max(decode(inp.name,c_SSP_weeks_name,
3730: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3731: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,
3732: max(decode(inp.name,c_SSP_days_due_name,
3733: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3734: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3735: max(decode(inp.name,c_qualifying_days_name,
3736: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3737: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS

Line 3736: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3732: max(decode(inp.name,c_SSP_days_due_name,
3733: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3734: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3735: max(decode(inp.name,c_qualifying_days_name,
3736: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3737: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3738: from pay_input_values_f inp,
3739: pay_element_entry_values_f eev,
3740: pay_element_entries_f ENTRY,