2122: from pay_element_type_rules petr
2123: where petr.element_set_id = p_element_set_id
2124: and petr.include_or_exclude = 'E')
2125: and not exists(select null
2126: from pay_element_type_usages_f npetu
2127: where npetu.element_type_id = petr.element_type_id
2128: and p_session_date between npetu.effective_start_date and npetu.effective_end_date
2129: and npetu.inclusion_flag = 'N'
2130: and npetu.run_type_id = p_run_type_id
2206: from pay_element_type_rules petr
2207: where petr.element_set_id = p_element_set_id
2208: and petr.include_or_exclude = 'E')
2209: and not exists(select null
2210: from pay_element_type_usages_f npetu
2211: where npetu.element_type_id = petr.element_type_id
2212: and p_session_date between npetu.effective_start_date and npetu.effective_end_date
2213: and npetu.inclusion_flag = 'N'
2214: and npetu.run_type_id = p_run_type_id