APPS.OKL_BPD_CAP_ADV_MON_PVT SQL Statements

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

Line: 152

    SELECT  lpt.contract_id
    FROM	OKL_BPD_LEASING_PAYMENT_TRX_V lpt
    WHERE	lpt.contract_number = cp_contract_num
    AND	    lpt.status = 'OP'
    AND	    lpt.amount_due_remaining > 0
    ORDER BY lpt.start_date;

Line: 161

   SELECT  authoring_org_id
   FROM   OKC_K_HEADERS_B
   WHERE  contract_number = cp_contract_num;

Line: 172

    SELECT  '1'
    FROM    OKL_TRX_CSH_RECEIPT_V
    WHERE   ile_id = cp_customer_id
    AND     check_number = cp_check_num
    AND     TRUNC(date_effective) = TRUNC(cp_receipt_date);

Line: 185

    SELECT  a.id, b.id
    FROM    OKL_TRX_CSH_RECEIPT_V a, OKL_TXL_RCPT_APPS_V b
    WHERE   a.id = b.rct_id_details
    AND     a.ile_id = cp_customer_id
    AND     a.check_number = cp_check_num
    AND     a.amount = cp_amount
    AND     b.khr_id = NVL(cp_contract_id, NULL);

Line: 197

    SELECT  bank_name, bank_account_num
    FROM    OKL_BPD_RCPT_MTHDS_UV
    WHERE   receipt_method_id = cp_irm_id;

Line: 205

    SELECT currency_code
    FROM okl_k_headers_full_v
    WHERE id = cp_contract_id;

Line: 543

     SELECT ID INTO l_xcr_id
     FROM   okl_ext_csh_rcpts_b
     WHERE  rct_id = l_rct_id;

Line: 564

       OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCAPB.pls call Okl_Rct_Pub.update_internal_trans ');

Line: 569

/*   Okl_Xcr_Pub.update_ext_csh_txns( p_api_version
                                    ,p_init_msg_list
                                    ,x_return_status
                                    ,x_msg_count
                                    ,x_msg_data
                                    ,l_xcrv_rec
                                    ,x_xcrv_rec
                                  );

Line: 578

    Okl_Rct_Pub.update_internal_trans (l_api_version
			    		       ,l_init_msg_list
				    	       ,l_return_status
				    	       ,l_msg_count
				    	       ,l_msg_data
					           ,l_rctv_rec
					           ,l_rcav_tbl
    					       ,x_rctv_rec
	    				       ,x_rcav_tbl);

Line: 590

       OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCAPB.pls call Okl_Rct_Pub.update_internal_trans ');