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.PAY_FR_SICKNESS_CALC dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 2177: from pay_element_entry_values_f peval_pst,

2173: --
2174: Select peval_pst.screen_entry_value pmt_start_date,
2175: peval_pet.screen_entry_value pmt_end_date
2176: --
2177: from pay_element_entry_values_f peval_pst,
2178: pay_element_entry_values_f peval_pet,
2179: pay_element_entries_f pentf,
2180: pay_element_links_f plink,
2181: pay_element_types_f peltf

Line 2178: pay_element_entry_values_f peval_pet,

2174: Select peval_pst.screen_entry_value pmt_start_date,
2175: peval_pet.screen_entry_value pmt_end_date
2176: --
2177: from pay_element_entry_values_f peval_pst,
2178: pay_element_entry_values_f peval_pet,
2179: pay_element_entries_f pentf,
2180: pay_element_links_f plink,
2181: pay_element_types_f peltf
2182: --

Line 3660: from pay_element_entry_values_f ENT_PT

3656: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band3_rate_iv_id,ENT_PT.screen_entry_value,null))) b3_rate
3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G
3662: ,pay_element_entries_f ENT
3663: ,pay_element_links_f EL
3664: where ENT_PT.element_entry_id = ENT.element_entry_id

Line 3661: ,pay_element_entry_values_f G

3657: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_iv_id,ENT_PT.screen_entry_value,null))) band4
3658: ,fnd_number.canonical_to_number(max(decode(ENT_PT.input_value_id,g_ben_band4_rate_iv_id,ENT_PT.screen_entry_value,null))) b4_rate
3659: ,max(decode(ENT_PT.input_value_id,g_ben_balance_iv_id,ENT_PT.screen_entry_value,null)) balance
3660: from pay_element_entry_values_f ENT_PT
3661: ,pay_element_entry_values_f G
3662: ,pay_element_entries_f ENT
3663: ,pay_element_links_f EL
3664: where ENT_PT.element_entry_id = ENT.element_entry_id
3665: and G.element_entry_id = ENT.element_entry_id

Line 4362: from pay_element_entry_values_f ev,

4358: ,p_effective_date in DATE) is
4359: select name,
4360: uom,
4361: substr(screen_entry_value,1,10) screen_entry_value
4362: from pay_element_entry_values_f ev,
4363: pay_input_values_f i
4364: where ev.element_entry_id = p_element_entry_id
4365: and ev.input_value_id + 0 = i.input_value_id
4366: and p_effective_date between