509: END;
510:
511: BEGIN
512:
513: -- populate jtf_type_qtype_usgs_all table with
514: -- qual_type_usg_id and terr_type_id
515: -- intersection table for jtf_qual_type_usgs_all and
516: -- jtf_terr_types_all tables
517:
514: -- qual_type_usg_id and terr_type_id
515: -- intersection table for jtf_qual_type_usgs_all and
516: -- jtf_terr_types_all tables
517:
518: insert into jtf_type_qtype_usgs_all
519: ( TYPE_QTYPE_USG_ID
520: , LAST_UPDATED_BY
521: , LAST_UPDATE_DATE
522: , CREATED_BY