DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on PAY_ELEMENT_ENTRIES_F

Line 350: pay_element_entries_f peef,

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

Line 384: pay_element_entries_f peef,

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