DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on PAY_ELEMENT_LINKS_F

Line 604: pay_element_links_f link

600: tax_previous
601: FROM pay_element_entries_f e,
602: pay_element_entry_values_f v,
603: pay_input_values_f iv,
604: pay_element_links_f link
605: WHERE e.assignment_id = p_asg_id
606: AND link.element_type_id = g_paye_details_id
607: AND e.element_link_id = link.element_link_id
608: AND e.element_entry_id = v.element_entry_id

Line 615: pay_element_links_f link1

611: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
612: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
613: AND e.effective_end_date = (select max(e1.effective_end_date)
614: from pay_element_entries_f e1,
615: pay_element_links_f link1
616: where link1.element_type_id = g_paye_details_id
617: and e1.assignment_id = p_asg_id
618: and e1.element_link_id = link1.element_link_id);
619: