DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_LINKS_F

Line 880: pay_element_links_f link

876: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
877: from pay_element_entries_f e,
878: pay_element_entry_values_f v,
879: pay_input_values_f iv,
880: pay_element_links_f link
881: where e.assignment_id = l_assignment_id
882: and link.element_type_id = l_paye_details_id
883: and e.element_link_id = link.element_link_id
884: and e.element_entry_id = v.element_entry_id

Line 895: pay_element_links_f link1

891: and e.effective_end_date between v.effective_start_date and v.effective_end_date ;
892: -- Bug 6643668 - this check is not reuqired
893: /*and e.effective_end_date = (select max(e1.effective_end_date)
894: from pay_element_entries_f e1,
895: pay_element_links_f link1
896: where link1.element_type_id = l_paye_details_id
897: and e1.assignment_id = l_assignment_id
898: and e1.element_link_id = link1.element_link_id);
899: */