DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on PAY_ELEMENT_ENTRIES_F

Line 601: FROM pay_element_entries_f e,

597: pay_previous,
598: max(decode(iv.name,'Tax Previous',
599: fnd_number.canonical_to_number(screen_entry_value),NULL))
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

Line 614: from pay_element_entries_f e1,

610: AND e.effective_end_date BETWEEN link.effective_start_date AND link.effective_end_date
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);