483: l_info_value number(12,3) := 0;
484: begin
485: select information_value
486: into l_info_value
487: from pay_ca_legislation_info
488: where information_type = p_info_type
489: and jurisdiction_code is NULL
490: and sv_reporting_year between to_char(start_date,'YYYY')
491: and to_char(end_date,'YYYY');
508: l_info_value number(12,3) := 0;
509: begin
510: select information_value
511: into l_info_value
512: from pay_ca_legislation_info
513: where information_type = p_info_type
514: and jurisdiction_code = p_jurisdiction
515: and sv_reporting_year between to_char(start_date,'YYYY')
516: and to_char(end_date,'YYYY');