660: l_is_temp_final_xml VARCHAR2(2);
661:
662: cursor cur_max_cpp_earning is
663: select information_value
664: from pay_ca_legislation_info
665: where information_type = 'MAX_CPP_EARNINGS'
666: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
667: between start_date and end_date;
668:
667: between start_date and end_date;
668:
669: cursor cur_max_ei_earning is
670: select information_value
671: from pay_ca_legislation_info
672: where information_type = 'MAX_EI_EARNINGS'
673: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
674: between start_date and end_date;
675:
674: between start_date and end_date;
675:
676: cursor cur_max_ppip_earning is
677: select information_value
678: from pay_ca_legislation_info
679: where information_type = 'MAX_PPIP_EARNINGS'
680: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
681: between start_date and end_date;
682: