DBA Data[Home] [Help]

APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on PAY_ELEMENT_TYPES_F

Line 351: pay_element_types_f petf,

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
355: and peef.assignment_id = paaf1.assignment_id

Line 385: pay_element_types_f petf,

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
389: and peef.assignment_id = paaf1.assignment_id