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

Line 165: pay_element_entry_values_f scon,

161: -- category. So if no category matches just get the earliest scon value on or
162: -- after the effective date
163: SELECT scon.screen_entry_value
164: FROM
165: pay_element_entry_values_f scon,
166: pay_element_entry_values_f cat
167: WHERE
168: scon.element_entry_id = p_element_entry_id
169: and cat.element_entry_id = p_element_entry_id

Line 166: pay_element_entry_values_f cat

162: -- after the effective date
163: SELECT scon.screen_entry_value
164: FROM
165: pay_element_entry_values_f scon,
166: pay_element_entry_values_f cat
167: WHERE
168: scon.element_entry_id = p_element_entry_id
169: and cat.element_entry_id = p_element_entry_id
170: and cat.effective_start_date = scon.effective_start_date

Line 475: ,pay_element_entry_values_f EV_SCON

471: from pay_balance_feeds_f FEED
472: ,pay_balance_types BAL
473: ,pay_run_result_values TARGET
474: ,pay_run_results RR
475: ,pay_element_entry_values_f EV_SCON
476: ,pay_element_entries_f E_NI
477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT

Line 1607: pay_element_entry_values_f v,

1603: l_people.effective_end_date,
1604: SCREEN_ENTRY_VALUE,
1605: 'Y'
1606: from pay_element_entries_f e,
1607: pay_element_entry_values_f v,
1608: pay_gb_year_end_payrolls ye_roll,
1609: pay_element_links_f link
1610: where e.assignment_id = l_people.assignment_id
1611: and v.input_value_id + 0 = l_category_input_id

Line 1709: pay_element_entry_values_f v,

1705: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1706: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1707: SCREEN_ENTRY_VALUE,null))) Tax_previous
1708: from pay_element_entries_f e,
1709: pay_element_entry_values_f v,
1710: pay_gb_year_end_payrolls ye_roll,
1711: pay_input_values_f iv,
1712: pay_element_links_f link
1713: where e.assignment_id = ye_asg.assignment_id

Line 1765: pay_element_entry_values_f v,

1761: SCREEN_ENTRY_VALUE,null))) Pay_previous,
1762: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Tax Previous',
1763: SCREEN_ENTRY_VALUE,null))) Tax_previous
1764: from pay_element_entries_f e,
1765: pay_element_entry_values_f v,
1766: pay_gb_year_end_payrolls ye_roll,
1767: pay_input_values_f iv,
1768: pay_element_links_f link
1769: where e.assignment_id = ye_asg.assignment_id