APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 413: pay_element_entries_f pee,

409: x_termination_date DATE) IS
410: SELECT peev.screen_entry_value
411: FROM pay_element_types_f pet,
412: pay_element_links_f pel,
413: pay_element_entries_f pee,
414: pay_input_values_f piv,
415: pay_element_entry_values_f peev
416: WHERE pee.assignment_id = x_assignment_id
417: AND upper(pet.element_name) = 'STUDENT LOAN'

Line 622: FROM pay_element_entries_f e,

618: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
619: max(decode(iv.name,'Tax Basis',screen_entry_value)) tax_basis,
620: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
621: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
622: FROM pay_element_entries_f e,
623: pay_element_entry_values_f v,
624: pay_input_values_f iv,
625: pay_element_links_f link
626: WHERE e.assignment_id = p_assignment_id

Line 635: from pay_element_entries_f e1,

631: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
632: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
633: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
634: AND e.effective_end_date = (select max(e1.effective_end_date)
635: from pay_element_entries_f e1,
636: pay_element_links_f link1
637: where link1.element_type_id = g_paye_details_id
638: and e1.assignment_id = p_assignment_id
639: and e1.element_link_id = link1.element_link_id);

Line 2952: FROM pay_element_entries_f e,

2948: max(decode(iv.name,'Pay Previous',screen_entry_value))
2949: pay_previous,
2950: max(decode(iv.name,'Tax Previous',screen_entry_value))
2951: tax_previous
2952: FROM pay_element_entries_f e,
2953: pay_element_entry_values_f v,
2954: pay_input_values_f iv,
2955: pay_element_links_f link
2956: WHERE e.assignment_id = p_assignment_id