346: and csr_v_effective_date between papf.effective_start_date and papf.effective_end_date
347: and csr_v_effective_date between paaf.effective_start_date and paaf.effective_end_date
348: and not exists (select '1'
349: from
350: pay_element_entries_f peef,
351: pay_element_types_f petf,
352: per_all_assignments_f paaf1
353: where peef.element_type_id = petf.element_type_id
354: and paaf1.person_id = papf.person_id
380: and csr_v_effective_date between paaf.effective_start_date and paaf.effective_end_date
381: and papf.sex = csr_v_sex
382: and not exists (select '1'
383: from
384: pay_element_entries_f peef,
385: pay_element_types_f petf,
386: per_all_assignments_f paaf1
387: where peef.element_type_id = petf.element_type_id
388: and paaf1.person_id = papf.person_id