APPS.PAY_P45_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 461: pay_element_entries_f pee,

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
465: AND upper(pet.element_name) = 'STUDENT LOAN'

Line 679: FROM pay_element_entries_f e,

675: SELECT max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
676: max(decode(iv.name,'Tax Basis',screen_entry_value)) tax_basis,
677: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
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

Line 692: from pay_element_entries_f e1,

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

Line 3337: FROM pay_element_entries_f e,

3333: max(decode(iv.name,'Pay Previous',screen_entry_value))
3334: pay_previous,
3335: max(decode(iv.name,'Tax Previous',screen_entry_value))
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