APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_ENTRIES_F

Line 687: from pay_element_entries_f e,

683: select max(decode(iv.name,'Tax Code',screen_entry_value)) tax_code,
684: max(decode(iv.name,'Tax Basis',screen_entry_value)) tax_basis,
685: max(decode(iv.name,'Pay Previous',screen_entry_value)) pay_previous,
686: max(decode(iv.name,'Tax Previous',screen_entry_value)) tax_previous
687: from pay_element_entries_f e,
688: pay_element_entry_values_f v,
689: pay_input_values_f iv,
690: pay_element_links_f link
691: where e.assignment_id = l_assignment_id

Line 704: from pay_element_entries_f e1,

700: and e.effective_end_date between iv.effective_start_date and iv.effective_end_date
701: and e.effective_end_date between v.effective_start_date and v.effective_end_date ;
702: -- Bug 6643668 - this check is not reuqired
703: /*and e.effective_end_date = (select max(e1.effective_end_date)
704: from pay_element_entries_f e1,
705: pay_element_links_f link1
706: where link1.element_type_id = l_paye_details_id
707: and e1.assignment_id = l_assignment_id
708: and e1.element_link_id = link1.element_link_id);

Line 1043: pay_element_entries_f ele,

1039: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1040: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1041: 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
1042: from pay_element_types_f elt,
1043: pay_element_entries_f ele,
1044: pay_input_values_f inv,
1045: pay_element_entry_values_f eev
1046: where elt.element_name = 'Student Loan'
1047: and ele.element_type_id = elt.element_type_id