[Home] [Help]
2015: (l_element_type IN NUMBER
2016: ,l_classification_id IN NUMBER
2017: ,l_report_date IN DATE) IS
2018: SELECT 'Y'
2019: FROM pay_sub_classification_rules_f
2020: WHERE element_type_id = l_element_type
2021: AND classification_id = l_classification_id
2022: AND l_report_date BETWEEN effective_start_date AND effective_end_date;
2023: --