APPS.CS_FETCH_ARTXN_INFO_PKG SQL Statements

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

Line: 9

		SELECT *
		FROM CS_CONTRACTS_BILLING
		WHERE trx_number is NULL
		FOR UPDATE OF contract_billing_id ;

Line: 43

		SELECT
	          lines.interface_line_attribute10,
	    		trx.cust_trx_type_id,
			trx.trx_number,
			lines.extended_amount,
			trtypes.type,
			trx.trx_date
    		INTO
	    		 temp_cp_service_trx_id,
			 trx_type_id,
		      trx_number,
			 trx_amount,
			 trx_class,
		      trx_date
		FROM  ra_customer_trx trx,
          	 ra_customer_trx_lines lines,
	     	 ra_cust_trx_types trtypes
     	WHERE lines.line_type='LINE'
		AND lines.interface_line_attribute1=to_char(cur_record.contract_id)
     	AND lines.interface_line_attribute2=to_char(cur_record.cp_service_id)
     	AND lines.interface_line_attribute4=to_char(cur_record.contract_billing_id)
     	AND trx.customer_trx_id=lines.customer_trx_id
     	AND trtypes.cust_trx_type_id=trx.cust_trx_type_id ;

Line: 83

			SELECT 	extended_amount
     		INTO      tax_amount
			FROM 	ra_customer_trx_lines
			WHERE 	line_type='TAX'
			AND interface_line_attribute1=to_char(cur_record.contract_id)
			AND interface_line_attribute2=to_char(cur_record.cp_service_id)
			AND interface_line_attribute4=to_char(cur_record.contract_billing_id);

Line: 104

	CS_CONBILLING_PVT.Update_Billing(
				p_api_version    	    => 1.0,
				p_init_msg_list         => 'T',
				p_commit			    => 'F',
				p_cp_service_trx_id     => temp_cp_service_trx_id,
			     p_contract_id 		    => cur_record.contract_id,
			     p_trx_type_id	         => trx_type_id,
				p_trx_number		    => trx_number,
				p_trx_date              => trx_date,
			     p_trx_pre_tax_amount    => trx_amount,
				p_tot_trx_amount        => trx_amount+tax_amount,
				p_contract_billing_id   => cur_record.contract_billing_id,
				p_obj_version_number    => cur_record.object_version_number,
				x_return_status         => v_return_status,
				x_msg_count             => v_msg_count,
				x_msg_data              => v_msg_data);

Line: 128

				'Successfully updated contracts billing');