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 3810: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,

3806: entry.assignment_id,
3807: entry.effective_start_date,
3808: entry.effective_end_date,
3809: max(decode(inp.name,c_rate_name,
3810: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3811: g_SSP_correction.input_currency_code)),null)) RATE,
3812: /* Use the SSP_correction's input_currency_code as *
3813: * the SSP_legislation global may not be populated */
3814: -------------------------------------------------------------------------

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

3820: -- which will convert the display format to a date. --
3821: -- This will fix bug 1020757. --
3822: -------------------------------------------------------------------------
3823: /* max(decode(inp.name,c_from_name, */
3824: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3825: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_FROM, */
3826: /* max(decode(inp.name,c_to_name, */
3827: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3828: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */

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

3823: /* max(decode(inp.name,c_from_name, */
3824: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3825: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_FROM, */
3826: /* max(decode(inp.name,c_to_name, */
3827: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3828: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3829: max(decode(inp.name,c_from_name,
3830: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3831: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,

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

3826: /* max(decode(inp.name,c_to_name, */
3827: /* to_date(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom, */
3828: /* g_SSP_correction.input_currency_code),'DD-MON-YYYY'),null)) DATE_TO, */
3829: max(decode(inp.name,c_from_name,
3830: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3831: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3832: max(decode(inp.name,c_to_name,
3833: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3834: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,

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

3829: max(decode(inp.name,c_from_name,
3830: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3831: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_FROM,
3832: max(decode(inp.name,c_to_name,
3833: fnd_date.chardate_to_date(hr_chkfmt.changeformat(eev.screen_entry_value,
3834: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3835: -- End of Changes for bug 1020757
3836: ------------------------------------------------------------------------
3837: max(decode(inp.name,c_amount_name,

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

3834: inp.uom,g_SSP_correction.input_currency_code)),null)) DATE_TO,
3835: -- End of Changes for bug 1020757
3836: ------------------------------------------------------------------------
3837: max(decode(inp.name,c_amount_name,
3838: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3839: g_SSP_correction.input_currency_code)),null)) AMOUNT,
3840: max(decode(inp.name,c_withheld_days_name,
3841: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3842: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,

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

3837: max(decode(inp.name,c_amount_name,
3838: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3839: g_SSP_correction.input_currency_code)),null)) AMOUNT,
3840: max(decode(inp.name,c_withheld_days_name,
3841: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3842: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,
3843: max(decode(inp.name,c_SSP_weeks_name,
3844: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3845: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,

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

3840: max(decode(inp.name,c_withheld_days_name,
3841: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3842: g_SSP_correction.input_currency_code)),null)) WITHHELD_DAYS,
3843: max(decode(inp.name,c_SSP_weeks_name,
3844: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3845: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,
3846: max(decode(inp.name,c_SSP_days_due_name,
3847: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3848: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,

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

3843: max(decode(inp.name,c_SSP_weeks_name,
3844: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3845: g_SSP_correction.input_currency_code)),null)) SSP_WEEKS,
3846: max(decode(inp.name,c_SSP_days_due_name,
3847: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3848: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3849: max(decode(inp.name,c_qualifying_days_name,
3850: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3851: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS

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

3846: max(decode(inp.name,c_SSP_days_due_name,
3847: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3848: g_SSP_correction.input_currency_code)),null)) SSP_DAYS_DUE,
3849: max(decode(inp.name,c_qualifying_days_name,
3850: to_number(hr_chkfmt.changeformat(eev.screen_entry_value,inp.uom,
3851: g_SSP_correction.input_currency_code)),null)) QUALIFYING_DAYS
3852: from pay_input_values_f inp,
3853: pay_element_entry_values_f eev,
3854: pay_element_entries_f ENTRY,