DBA Data[Home] [Help]

APPS.HR_DE_TAX_SUPPORT dependencies on PAY_ELEMENT_ENTRIES_F

Line 407: from pay_element_entries_f pee

403: and to_char(hdt.effective_start_date,'YYYY') < to_char(p_date_from,'YYYY')
404: and nvl(hdt.effective_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')) > p_date_from
405: and hdt.tax_class IN ('I','II','III','IV','V','VI')
406: and hdt.effective_start_date = ( select max(effective_start_date)
407: from pay_element_entries_f pee
408: where pee.element_entry_id = hdt.element_entry_id
409: and pee.assignment_id = hdt.assignment_id);
410:
411: l_var varchar2(1);