[Home] [Help]
90: PET.effective_end_date
91: AND p_effective_date BETWEEN PEL.effective_start_date AND
92: PEL.effective_end_date
93: AND EXISTS (SELECT 'x'
94: FROM pay_element_classifications PEC
95: WHERE PEC.classification_id = PET.classification_id
96: AND PEC.classification_name = 'Alien/Expat Earnings'
97: AND PEC.legislation_code = 'US' );
98: