734: l_la_code2 := 'ZLM';
735: END IF;
736: END IF;
737:
738: l_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code1);
739: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);
740:
741: IF (l_la_code1 = 'ZLM') THEN
742: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';
735: END IF;
736: END IF;
737:
738: l_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code1);
739: l_la_desc2 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY',l_la_code2);
740:
741: IF (l_la_code1 = 'ZLM') THEN
742: l_insrt_value := 'P.L. 108-411, Sec. 301 dated 10-30-04.';
743: ghr_mass_actions_pkg.replace_insertion_values