APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_ELEMENT_ENTRIES_F

Line 476: ,pay_element_entries_f E_NI

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
480: ,pay_payroll_actions BACT

Line 1606: from pay_element_entries_f e,

1602: select l_people.assignment_id,
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

Line 1708: from pay_element_entries_f e,

1704: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
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

Line 1764: from pay_element_entries_f e,

1760: 100 * fnd_number.canonical_to_number(max(decode(iv.name,'Pay Previous',
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