APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_ENTRIES_F

Line 877: from pay_element_entries_f e,

873: select max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
874: max(decode(iv.name,'Tax Basis',screen_entry_value)) tax_basis,
875: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
876: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
877: from pay_element_entries_f e,
878: pay_element_entry_values_f v,
879: pay_input_values_f iv,
880: pay_element_links_f link
881: where e.assignment_id = l_assignment_id

Line 894: from pay_element_entries_f e1,

890: and e.effective_end_date between iv.effective_start_date and iv.effective_end_date
891: and e.effective_end_date between v.effective_start_date and v.effective_end_date ;
892: -- Bug 6643668 - this check is not reuqired
893: /*and e.effective_end_date = (select max(e1.effective_end_date)
894: from pay_element_entries_f e1,
895: pay_element_links_f link1
896: where link1.element_type_id = l_paye_details_id
897: and e1.assignment_id = l_assignment_id
898: and e1.element_link_id = link1.element_link_id);

Line 1244: pay_element_entries_f ele,

1240: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1241: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1242: fnd_date.date_to_canonical(min(decode(inv.name, 'End Date', eev.effective_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00')))) eff_date
1243: from pay_element_types_f elt,
1244: pay_element_entries_f ele,
1245: pay_input_values_f inv,
1246: pay_element_entry_values_f eev
1247: where elt.element_name = 'Student Loan'
1248: and ele.element_type_id = elt.element_type_id