866: ,l_org_information19
867: ,l_org_information20 ;
868: CLOSE csr_org_info;
869:
870: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
871: l_org_information1 := p_org_information1;
872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;
869:
870: IF NVL(p_org_information1,'X') <> hr_api.g_varchar2 THEN
871: l_org_information1 := p_org_information1;
872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;
875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;
872: END IF;
873: IF NVL(p_org_information2,'X') <> hr_api.g_varchar2 THEN
874: l_org_information2 := p_org_information2;
875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;
878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;
875: END IF;
876: IF NVL(p_org_information3,'X') <> hr_api.g_varchar2 THEN
877: l_org_information3 := p_org_information3;
878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;
881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;
878: END IF;
879: IF NVL(p_org_information4,'X') <> hr_api.g_varchar2 THEN
880: l_org_information4 := p_org_information4;
881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;
884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;
881: END IF;
882: IF NVL(p_org_information5,'X') <> hr_api.g_varchar2 THEN
883: l_org_information5 := p_org_information5;
884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;
887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;
884: END IF;
885: IF NVL(p_org_information6,'X') <> hr_api.g_varchar2 THEN
886: l_org_information6 := p_org_information6;
887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;
890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;
887: END IF;
888: IF NVL(p_org_information7,'X') <> hr_api.g_varchar2 THEN
889: l_org_information7 := p_org_information7;
890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;
893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;
890: END IF;
891: IF NVL(p_org_information8,'X') <> hr_api.g_varchar2 THEN
892: l_org_information8 := p_org_information8;
893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;
896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;
893: END IF;
894: IF NVL(p_org_information9,'X') <> hr_api.g_varchar2 THEN
895: l_org_information9 := p_org_information9;
896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;
899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;
896: END IF;
897: IF NVL(p_org_information10,'X') <> hr_api.g_varchar2 THEN
898: l_org_information10 := p_org_information10;
899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;
902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;
899: END IF;
900: IF NVL(p_org_information11,'X') <> hr_api.g_varchar2 THEN
901: l_org_information11 := p_org_information11;
902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;
905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;
902: END IF;
903: IF NVL(p_org_information12,'X') <> hr_api.g_varchar2 THEN
904: l_org_information12 := p_org_information12;
905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;
908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;
905: END IF;
906: IF NVL(p_org_information13,'X') <> hr_api.g_varchar2 THEN
907: l_org_information13 := p_org_information13;
908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;
911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;
908: END IF;
909: IF NVL(p_org_information14,'X') <> hr_api.g_varchar2 THEN
910: l_org_information14 := p_org_information14;
911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;
914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;
911: END IF;
912: IF NVL(p_org_information15,'X') <> hr_api.g_varchar2 THEN
913: l_org_information15 := p_org_information15;
914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;
917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;
914: END IF;
915: IF NVL(p_org_information16,'X') <> hr_api.g_varchar2 THEN
916: l_org_information16 := p_org_information16;
917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;
920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;
917: END IF;
918: IF NVL(p_org_information17,'X') <> hr_api.g_varchar2 THEN
919: l_org_information17 := p_org_information17;
920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;
923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;
920: END IF;
921: IF NVL(p_org_information18,'X') <> hr_api.g_varchar2 THEN
922: l_org_information18 := p_org_information18;
923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;
926: END IF;
927: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
928: l_org_information20 := p_org_information20;
923: END IF;
924: IF NVL(p_org_information19,'X') <> hr_api.g_varchar2 THEN
925: l_org_information19 := p_org_information19;
926: END IF;
927: IF NVL(p_org_information20,'X') <> hr_api.g_varchar2 THEN
928: l_org_information20 := p_org_information20;
929: END IF;
930:
931: -- Call check_cn_org_internal