[Home] [Help]
709: END LOOP; -- FOR project_types_r IN sel_project_types
710:
711: SELECT COUNT(*)
712: INTO x_count
713: FROM PA_ALL_PRJ_TYPES_IT;
714:
715: IF x_count = 0
716: THEN
717: INSERT INTO PA_ALL_PRJ_TYPES_IT
713: FROM PA_ALL_PRJ_TYPES_IT;
714:
715: IF x_count = 0
716: THEN
717: INSERT INTO PA_ALL_PRJ_TYPES_IT
718: (
719: ALL_PROJECT_TYPES,
720: LAST_UPDATE_DATE,
721: LAST_UPDATED_BY,