DBA Data[Home] [Help]

APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_LINKS_F

Line 690: pay_element_links_f link

686: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
687: from pay_element_entries_f e,
688: pay_element_entry_values_f v,
689: pay_input_values_f iv,
690: pay_element_links_f link
691: where e.assignment_id = l_assignment_id
692: and link.element_type_id = l_paye_details_id
693: and e.element_link_id = link.element_link_id
694: and e.element_entry_id = v.element_entry_id

Line 705: pay_element_links_f link1

701: and e.effective_end_date between v.effective_start_date and v.effective_end_date ;
702: -- Bug 6643668 - this check is not reuqired
703: /*and e.effective_end_date = (select max(e1.effective_end_date)
704: from pay_element_entries_f e1,
705: pay_element_links_f link1
706: where link1.element_type_id = l_paye_details_id
707: and e1.assignment_id = l_assignment_id
708: and e1.element_link_id = link1.element_link_id);
709: */