DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 2547: pay_element_types_f ELT

2543: select piv.default_value,
2544: piv.effective_start_date,
2545: piv.effective_end_date
2546: from pay_input_values_f PIV,
2547: pay_element_types_f ELT
2548: where elt.element_type_id = piv.element_type_id
2549: and elt.element_type_id = g_SSP_legislation.element_type_id
2550: and p_effective_date between piv.effective_start_date and piv.effective_end_date
2551: and p_effective_date between elt.effective_start_date and elt.effective_end_date