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_GB_EOY_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 325: pay_element_entry_values_f scon,

321: -- category. So if no category matches just get the nearest scon value
322: --
323: SELECT scon.screen_entry_value
324: FROM
325: pay_element_entry_values_f scon,
326: pay_element_entry_values_f cat
327: WHERE scon.element_entry_id = p_element_entry_id
328: AND cat.element_entry_id = p_element_entry_id
329: AND cat.effective_start_date = scon.effective_start_date

Line 326: pay_element_entry_values_f cat

322: --
323: SELECT scon.screen_entry_value
324: FROM
325: pay_element_entry_values_f scon,
326: pay_element_entry_values_f cat
327: WHERE scon.element_entry_id = p_element_entry_id
328: AND cat.element_entry_id = p_element_entry_id
329: AND cat.effective_start_date = scon.effective_start_date
330: AND cat.effective_end_date = scon.effective_end_date

Line 3452: ,pay_element_entry_values_f ev_scon

3448: FROM pay_balance_feeds_f feed
3449: ,pay_balance_types bal
3450: ,pay_run_result_values target
3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3455: ,pay_element_links_f el_ni
3456: ,pay_payroll_actions pact

Line 3453: ,pay_element_entry_values_f ev_cat

3449: ,pay_balance_types bal
3450: ,pay_run_result_values target
3451: ,pay_run_results rr
3452: ,pay_element_entry_values_f ev_scon
3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3455: ,pay_element_links_f el_ni
3456: ,pay_payroll_actions pact
3457: ,pay_assignment_actions assact

Line 3537: pay_element_entry_values_f v,

3533: SELECT v.screen_entry_value ni_cat,
3534: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3535: ,1,9) ni_scon
3536: FROM pay_element_entries_f e,
3537: pay_element_entry_values_f v,
3538: pay_element_entry_values_f scon,
3539: pay_element_links_f link
3540: WHERE e.assignment_id = p_asgid
3541: AND v.input_value_id + 0 = g_category_input_id

Line 3538: pay_element_entry_values_f scon,

3534: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3535: ,1,9) ni_scon
3536: FROM pay_element_entries_f e,
3537: pay_element_entry_values_f v,
3538: pay_element_entry_values_f scon,
3539: pay_element_links_f link
3540: WHERE e.assignment_id = p_asgid
3541: AND v.input_value_id + 0 = g_category_input_id
3542: AND v.effective_start_date = scon.effective_start_date

Line 3680: pay_element_entry_values_f v,

3676: 100 * max(decode(iv.name,'Tax Previous',
3677: fnd_number.canonical_to_number(screen_entry_value),NULL))
3678: tax_previous
3679: FROM pay_element_entries_f e,
3680: pay_element_entry_values_f v,
3681: pay_input_values_f iv,
3682: pay_element_links_f link
3683: WHERE e.assignment_id = p_assignment_id
3684: AND link.element_type_id = g_paye_details_id