APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 460: pay_element_links_f pel,

456: cursor csr_getdate (x_assignment_id NUMBER,
457: x_termination_date DATE) IS
458: SELECT peev.screen_entry_value
459: FROM pay_element_types_f pet,
460: pay_element_links_f pel,
461: pay_element_entries_f pee,
462: pay_input_values_f piv,
463: pay_element_entry_values_f peev
464: WHERE pee.assignment_id = x_assignment_id

Line 682: pay_element_links_f link

678: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
679: FROM pay_element_entries_f e,
680: pay_element_entry_values_f v,
681: pay_input_values_f iv,
682: pay_element_links_f link
683: WHERE e.assignment_id = p_assignment_id
684: AND link.element_type_id = g_paye_details_id
685: AND e.element_link_id = link.element_link_id
686: AND e.element_entry_id = v.element_entry_id

Line 693: pay_element_links_f link1

689: AND e.effective_end_date BETWEEN iv.effective_start_date AND iv.effective_end_date
690: AND e.effective_end_date BETWEEN v.effective_start_date AND v.effective_end_date
691: AND e.effective_end_date = (select max(e1.effective_end_date)
692: from pay_element_entries_f e1,
693: pay_element_links_f link1
694: where link1.element_type_id = g_paye_details_id
695: and e1.assignment_id = p_assignment_id
696: and e1.element_link_id = link1.element_link_id);
697: begin

Line 3340: pay_element_links_f link

3336: tax_previous
3337: FROM pay_element_entries_f e,
3338: pay_element_entry_values_f v,
3339: pay_input_values_f iv,
3340: pay_element_links_f link
3341: WHERE e.assignment_id = p_assignment_id
3342: AND link.element_type_id = g_paye_details_id
3343: AND e.element_link_id = link.element_link_id
3344: AND e.element_entry_id = v.element_entry_id