APPS.OKL_COPY_TEMPLATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 36

SELECT   ID
        ,OBJECT_VERSION_NUMBER
        ,TRY_ID
        ,AES_ID
        ,STY_ID
        ,FMA_ID
        ,SET_OF_BOOKS_ID
        ,FAC_CODE
        ,SYT_CODE
        -- Added code by HKPATEL for Bug# 2943310
        ,INV_CODE
        -- Added code ends here
        ,POST_TO_GL
        ,ADVANCE_ARREARS
        ,MEMO_YN
        ,PRIOR_YEAR_YN
        ,NAME
        ,DESCRIPTION
        ,VERSION
        ,FACTORING_SYND_FLAG
        ,START_DATE
        ,END_DATE
        ,ATTRIBUTE_CATEGORY
        ,ATTRIBUTE1
        ,ATTRIBUTE2
        ,ATTRIBUTE3
        ,ATTRIBUTE4
        ,ATTRIBUTE5
        ,ATTRIBUTE6
        ,ATTRIBUTE7
        ,ATTRIBUTE8
        ,ATTRIBUTE9
        ,ATTRIBUTE10
        ,ATTRIBUTE11
        ,ATTRIBUTE12
        ,ATTRIBUTE13
        ,ATTRIBUTE14
        ,ATTRIBUTE15
        ,ORG_ID
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
FROM OKL_AE_TEMPLATES
WHERE aes_id = v_aes_id;

Line: 85

SELECT  ID
       ,SEQUENCE_NUMBER
       ,AVL_ID
       ,CODE_COMBINATION_ID
       ,AE_LINE_TYPE
       ,CRD_CODE
       ,OBJECT_VERSION_NUMBER
       ,ACCOUNT_BUILDER_YN
       ,DESCRIPTION
       ,PERCENTAGE
       ,ATTRIBUTE_CATEGORY
       ,ATTRIBUTE1
       ,ATTRIBUTE2
       ,ATTRIBUTE3
       ,ATTRIBUTE4
       ,ATTRIBUTE5
       ,ATTRIBUTE6
       ,ATTRIBUTE7
       ,ATTRIBUTE8
       ,ATTRIBUTE9
       ,ATTRIBUTE10
       ,ATTRIBUTE11
       ,ATTRIBUTE12
       ,ATTRIBUTE13
       ,ATTRIBUTE14
       ,ATTRIBUTE15
       ,ORG_ID
       ,CREATED_BY
       ,CREATION_DATE
       ,LAST_UPDATED_BY
       ,LAST_UPDATE_DATE
       ,LAST_UPDATE_LOGIN
FROM OKL_AE_TMPT_LNES
WHERE avl_id = v_avl_id;

Line: 180

		    l_atlv_tbl_in.DELETE;