APPS.PAY_GB_RTI_EYU dependencies on PAY_ELEMENT_ENTRIES_F

Line 635: FROM pay_element_entries_f e,

631:
632: CURSOR csr_paye_details(p_assignment_id NUMBER) IS
633: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
634: max(decode(iv.name,'Tax Basis',DECODE(screen_entry_value,'N','Y',NULL),NULL)) tax_basis -- kvinayku bug no 14774165
635: FROM pay_element_entries_f e,
636: pay_element_entry_values_f v,
637: pay_input_values_f iv,
638: pay_element_links_f link
639: WHERE e.assignment_id = p_assignment_id

Line 648: from pay_element_entries_f e1,

644: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
645: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
646: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
647: AND e.effective_end_date = (select max(e1.effective_end_date)
648: from pay_element_entries_f e1,
649: pay_element_links_f link1
650: where link1.element_type_id = g_paye_details_id
651: and e1.assignment_id = p_assignment_id
652: and e1.element_link_id = link1.element_link_id);