DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_ELEMENT_LINKS_F

Line 638: pay_element_links_f link

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
640: AND link.element_type_id = g_paye_details_id
641: AND e.element_link_id = link.element_link_id
642: AND e.element_entry_id = v.element_entry_id

Line 649: pay_element_links_f link1

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);
653: