delete legal_person_spoken_language
where muid = :P19_MUID;
FOR i in 1..APEX_APPLICATION.G_F02.count
LOOP
if APEX_APPLICATION.G_F02(i) is not null then
   insert into legal_person_spoken_language(muid, language_code)
   values(:P19_muid, APEX_APPLICATION.G_F02(i));
end if;
END LOOP;

delete legal_person_expertise_area
where muid =  :P19_MUID;
FOR i in 1..APEX_APPLICATION.G_F01.count
LOOP
if APEX_APPLICATION.G_F01(i) is not null then
   insert into legal_person_expertise_area(muid, expertise_area_id)
   values(:P19_muid, APEX_APPLICATION.G_F01(i));
end if;
END LOOP;

delete legal_person_spoken_language
where muid =  :P19_MUID;
FOR i in 1..APEX_APPLICATION.G_F02.count
LOOP
if APEX_APPLICATION.G_F02(i) is not null then
   insert into legal_person_spoken_language(muid, language_code)
   values(:P19_muid, APEX_APPLICATION.G_F02(i));
end if;
END LOOP;


delete legal_person_role
where muid = :P19_MUID;
FOR i in 1..APEX_APPLICATION.G_F03.count
LOOP
if APEX_APPLICATION.G_F03(i) is not null then
   insert into legal_person_role(muid, legal_role_code)
   values(:P19_muid, APEX_APPLICATION.G_F03(i));
end if;
END LOOP;


delete LEGAL_PERSON_PRACTICE_GROUP
where MUID = :P19_MUID;
FOR i in 1..APEX_APPLICATION.G_F04.count
LOOP
if APEX_APPLICATION.G_F04(i) is not null then
   insert into LEGAL_PERSON_PRACTICE_GROUP(MUID, PRACTICE_GROUP_ID)
   values(:P19_MUID, APEX_APPLICATION.G_F04(i));
end if;
END LOOP;

select 
ea.expertise_area_id,
ea.expertise_area_name,
APEX_ITEM.CHECKBOX(1,ea.expertise_area_id,DECODE(lpea.expertise_area_id,null,'','CHECKED') ) sel
from LEGAL_PERSON_EXPERTISE_AREA lpea, expertise_area ea
where MUID (+)= :P8_MUID
  and lpea.expertise_area_id (+)= ea.expertise_area_id
order by muid, ea.expertise_area_name

select 
ea.language_code,
ea.language_name name,
APEX_ITEM.CHECKBOX(2,ea.language_code,DECODE(lpea.language_code,null,'','CHECKED') ) sel
from LEGAL_PERSON_spoken_language lpea, spoken_language ea
where MUID (+)= :P8_MUID
  and lpea.language_code (+)= ea.language_code
order by muid, language_name

select 
ea.legal_role_code,
ea.legal_role_name name,
APEX_ITEM.CHECKBOX(3,ea.legal_role_code,DECODE(lpea.legal_role_code,null,'','CHECKED') ) sel
from LEGAL_PERSON_role lpea, legal_role ea
where MUID (+)= :P8_MUID
  and lpea.legal_role_code (+)= ea.legal_role_code

select 
ea.practice_group_id,
ea.practice_group_name name,
APEX_ITEM.CHECKBOX(4,lpea.practice_group_id,DECODE(lpea.practice_group_id,null,'','CHECKED') ) sel
from LEGAL_PERSON_practice_group lpea, practice_group ea
where MUID (+)= :P8_MUID
  and lpea.practice_group_id (+)= ea.practice_group_id