APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 412: pay_element_links_f pel,

408: cursor csr_getdate (x_assignment_id NUMBER,
409: x_termination_date DATE) IS
410: SELECT peev.screen_entry_value
411: FROM pay_element_types_f pet,
412: pay_element_links_f pel,
413: pay_element_entries_f pee,
414: pay_input_values_f piv,
415: pay_element_entry_values_f peev
416: WHERE pee.assignment_id = x_assignment_id

Line 625: pay_element_links_f link

621: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
622: FROM pay_element_entries_f e,
623: pay_element_entry_values_f v,
624: pay_input_values_f iv,
625: pay_element_links_f link
626: WHERE e.assignment_id = p_assignment_id
627: AND link.element_type_id = g_paye_details_id
628: AND e.element_link_id = link.element_link_id
629: AND e.element_entry_id = v.element_entry_id

Line 636: pay_element_links_f link1

632: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
633: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
634: AND e.effective_end_date = (select max(e1.effective_end_date)
635: from pay_element_entries_f e1,
636: pay_element_links_f link1
637: where link1.element_type_id = g_paye_details_id
638: and e1.assignment_id = p_assignment_id
639: and e1.element_link_id = link1.element_link_id);
640: begin

Line 2955: pay_element_links_f link

2951: tax_previous
2952: FROM pay_element_entries_f e,
2953: pay_element_entry_values_f v,
2954: pay_input_values_f iv,
2955: pay_element_links_f link
2956: WHERE e.assignment_id = p_assignment_id
2957: AND link.element_type_id = g_paye_details_id
2958: AND e.element_link_id = link.element_link_id
2959: AND e.element_entry_id = v.element_entry_id