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 349: pay_element_entry_values_f scon,

345: -- category. So if no category matches just get the nearest scon value
346: --
347: SELECT scon.screen_entry_value
348: FROM
349: pay_element_entry_values_f scon,
350: pay_element_entry_values_f cat
351: WHERE scon.element_entry_id = p_element_entry_id
352: AND cat.element_entry_id = p_element_entry_id
353: AND cat.effective_start_date = scon.effective_start_date

Line 350: pay_element_entry_values_f cat

346: --
347: SELECT scon.screen_entry_value
348: FROM
349: pay_element_entry_values_f scon,
350: pay_element_entry_values_f cat
351: WHERE scon.element_entry_id = p_element_entry_id
352: AND cat.element_entry_id = p_element_entry_id
353: AND cat.effective_start_date = scon.effective_start_date
354: AND cat.effective_end_date = scon.effective_end_date

Line 3587: ,pay_element_entry_values_f ev_scon

3583: FROM pay_balance_feeds_f feed
3584: ,pay_balance_types bal
3585: ,pay_run_result_values target
3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3590: ,pay_element_links_f el_ni
3591: ,pay_payroll_actions pact

Line 3588: ,pay_element_entry_values_f ev_cat

3584: ,pay_balance_types bal
3585: ,pay_run_result_values target
3586: ,pay_run_results rr
3587: ,pay_element_entry_values_f ev_scon
3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3590: ,pay_element_links_f el_ni
3591: ,pay_payroll_actions pact
3592: ,pay_assignment_actions assact

Line 3675: pay_element_entry_values_f v,

3671: SELECT v.screen_entry_value ni_cat,
3672: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3673: ,1,9) ni_scon
3674: FROM pay_element_entries_f e,
3675: pay_element_entry_values_f v,
3676: pay_element_entry_values_f scon,
3677: pay_element_links_f link
3678: WHERE e.assignment_id = p_asgid
3679: AND v.input_value_id + 0 = g_category_input_id

Line 3676: pay_element_entry_values_f scon,

3672: substr(hr_general.decode_lookup('GB_SCON',scon.screen_entry_value)
3673: ,1,9) ni_scon
3674: FROM pay_element_entries_f e,
3675: pay_element_entry_values_f v,
3676: pay_element_entry_values_f scon,
3677: pay_element_links_f link
3678: WHERE e.assignment_id = p_asgid
3679: AND v.input_value_id + 0 = g_category_input_id
3680: AND v.effective_start_date = scon.effective_start_date

Line 3821: pay_element_entry_values_f v,

3817: 100 * max(decode(iv.name,'Tax Previous',
3818: fnd_number.canonical_to_number(screen_entry_value),NULL))
3819: tax_previous
3820: FROM pay_element_entries_f e,
3821: pay_element_entry_values_f v,
3822: pay_input_values_f iv,
3823: pay_element_links_f link
3824: WHERE e.assignment_id = p_assignment_id
3825: AND link.element_type_id = g_paye_details_id