330: select /*+ ORDERED use_nl(paa,paaf,etype,entry) */
331: entry.element_entry_id,
332: entry.effective_start_date
333: from per_all_assignments_f PAAF,
334: pay_element_types_f ETYPE,
335: pay_element_entries_f ENTRY
336: where PAAF.person_id = person.person_id
337: and ETYPE.element_name = c_PAD_element_name
338: and ETYPE.legislation_code = 'GB'
355: -- Do not select reversal entries
356: --
357: select 1
358: from pay_element_links_f LINK,
359: pay_element_types_f TYPE
360: where link.element_link_id = entry.element_link_id
361: and entry.effective_start_date between link.effective_start_date and link.effective_end_date
362: and link.element_type_id = type.element_type_id
363: and link.effective_start_date between type.effective_start_date and type.effective_end_date
1032: -- Do not select reversal entries
1033: --
1034: select 1
1035: from pay_element_links_f LINK,
1036: pay_element_types_f TYPE
1037: where link.element_link_id = entry.element_link_id
1038: and entry.effective_start_date between link.effective_start_date
1039: and link.effective_end_date
1040: and link.element_type_id = type.element_type_id